1.3 Direct Connection to MySQL Server

fmPreferencesOpenCart

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

Store Manager for OpenCart requires direct MySQL database connection. Most of hosting companies allow direct connections to MySQL database.

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 checkbox

Direct connection type

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

  • MySQL Host (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).
  • MySQL Version - Most of hosting companies have 4.1 or 4.0 and some of them have 5.x version. You can use Auto if you're not sure which one is used.
  • User name (login)Password and Database (name) - Specify your username, password and database name. You can find them at the bottom of config.php file (it looks like in the illustration below):
Example of config.php file


You may type database name manually or use 'Select Database' button to see the list of available databases and select the one you need from the drop-down.

Select database button


Tip: Use the Test Connection button to verify if all settings are correct and connection to your remote database is possible.

Test Connection button


4. Click OK to save this entry, close Preferences and to connect to your database, or click cancel to discard this entry.
 
If you're unable to connect to the remote database, here are few key items to check. 
 
If you got such message as:


 (where 'user' is your username and '194.187.228.147' 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.

Please see our troubleshooter at support.emagicone.com under Troubleshooter >> Configure Database Connection to get a step-by-step assistance.

By eMagicOne Inc.

Comments