1.3. Direct Connection to MySQL Database
Let's check step-by-step instruction on how to configure a direct connection to your store database.
1. Go to Settings -> Preferences -> Database Connection and enable "Direct Connection to the store database" checkbox.
2. You have to specify the following settings to be able to connect:
- "MySQL Host" (i.e. Server Address). Usually it is your website name like "mywebsite.com" or "servername.com" (do not include http://www. prefix); you may use IP address, as well. Please check your store server parameters (see global.inc.php, most likely you can find it at your store /includes directory). There, you can find your database server name (host).
$glob['dbhost'] = 'servername.com'
If any is defined here (like http://www.servername.com), you should use the one (servername.com).
If it is defined as "localhost", it means you should use your store name.
Port - 3306 is used in most cases (please ask your hosting provider to check if the one is used).
- "Username" (login), "Password" and "Database" (name). Specify your username, password and database name. You can find them at the bottom of global.inc.php file:
$glob['dbdatabase'] = 'remote_database_name' //your database name is defined here
$glob['dbpassword'] = 'password' //your password is defined here
$glob['dbusername'] = 'username' //your User Name (login) is defined here
You may type database name manually or use [Select Database] to see the list of available databases and select the one you need from the drop-down.
Tip: Use the [Test Connection] button to verify whether all settings are correct and connection to your remote database is possible.
3. Click [OK] to save this entry, close "Preferences" to connect to your database, or click [Cancel] to discard this entry.
If you're unable to connect to a remote database, here are a few key items to check.
If you got such message as: