2. Direct Connection to MySQL Server

fmPreferences - fmDirectConnection

This section describes how to setup direct connection to your MySQL server.

Store Manager for CubeCart requires direct MySQL database connection. Most of hosting companies allow direct connections to MySQL database. However in most cases you have to go to your control panel and add your home/office computer IP address or domain name to Access List - list of IP addresses allowed to access MySQL port 3306 from outside. This option can be found under MySQL settings.

Feel free to ask your hosting support to assist you in enabling direct MySQL access, they must help you since it is trivial task.

To configure direct connection to your remote database, follow few steps:

1. Open Tools -> Preferences -> Database Connection Tab

2. Enable Direct connection to remote database check-box

3. Specify the following Remote (Direct) Database Connection Settings:

$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.

$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 browse button [...] 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 if all settings are correct and connection to your remote database is possible.

4. Click Ok to save this entry, close Preferences and to connect to your database, or click cancel to discard this entry.


Also you can use Database Connection wizard to setup your connection or make Database backup/Restore using corresponding options.

If you're unable to connect to remote database, here are few key items to check. 


If you got "SQL ERROR: Access denied for user 'admin'@'' (using Password: YES)" notification (where 'admin' is your username and '' is your IP) you have to add your IP address to the Access List and allow direct MySQL connections. Please see an article to find out how to add your IP to the Access List.