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.

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 global.inc.php file:

If you got "SQL ERROR: Access denied for user
'admin'@'91.203.79.82' (using Password: YES)" notification (where
'admin' is your username and '91.203.79.82' 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.