Pixel & Tonic: Craft
Out of context: Reply #12
- Started
- Last post
- 16 Responses
- nb0
<?php
/**
* Database Configuration
*
* All of your system's database configuration settings go in here.
* You can see a list of the default settings in craft/app/etc/config/defaults/db.php
*/return array(
// The database server name or IP address. Usually this is 'localhost' or '127.0.0.1'.
'server' => 'localhost',/**
* The database server port.
*/
'port' => '3306',// The database username to connect with.
'user' => 'nathan_user',// The database password to connect with.
'password' => 'REDACTED',// The name of the database to select.
'database' => 'nathan_craftdb',// The prefix to use when naming tables. This can be no more than 5 characters.
'tablePrefix' => 'craft',
/**
* The charset to use when creating tables.
*/
'charset' => 'utf8',/**
* The collation to use when creating tables.
*/
'collation' => 'utf8_unicode_ci');
- Like I said, I've had no problem connecting to the database with Sequel Pro. This is not a MAMP install, it's on a web server.nb
- Nothing jumps out at me...ETM
- Yeah, it's pretty straightforward.nb
- That's what's so maddening.nb
- One thought I had: In order to connect to the DB via Sequel Pro, I had to use the "Remote MYSQL" feature in cpanel. I wonder if I need to allow a special IP fornb
- accessing the DB from the browser...? I mean, it seems that it would be localhost 127.0.0.1, which is already on the list of remote connections.nb
- You mean whitelisting your local IP? That shouldn't be relevant for accessing the Craft CP because yes, the php files are accessing localhost.ETM
- Are you moving from local to an actual web server (remote host with a domain etc)?estetic
- No, I'm not moving it. Just setting it up on a web server so I can learn it.nb