Navigation

2. Direct Connection to MySQL Server

fmPreferences - fmDirectConnection 

    If you use Standard Edition of Store Manager for Magento, the number of Store connection is limited to one (1).
In case you need to manage more than one store, you need to upgrade to PRO Edition. Please click here to find more details: http://www.mag-manager.com/store-manager-for-magento-plans-and-pricing

1. Database connection

This section describes how to set up direct connection to your MySQL server using Store Manager for Magento.

Store Manager for Magento 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 Settings -> Preferences -> Database Connection Tab (F12)

2. Enable Direct connection to remote database check-box


3. Specify the following Remote Database Connection Settings:

  • Host (Server address) - Usually it is your website name like "mywebsite.com" (do not include http://www. prefix); you may use IP address as well. Please check your store server parameters (see local.xml, you can find it at your store /app/etc directory). Open local.xml file and you will find your database server name (host).

    <host><![CDATA[mywebsite.com]]></host>
  • 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 in local.xml file as well:

    <username><![CDATA[name]]></username>                //here your User Name (login) is defined
    <password><![CDATA[pass]]></password>                   //here your password is defined
    <dbname><![CDATA[remote_database]]></dbname>    //here your database name is defined

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

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 set up 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'@'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.

2. Advanced Database Settings


Advanced Database Settings allow you to set up additional settings for your current database.

Use MySQL protocol compression - Use the Compress property to use compression on transferring data. Setting this property to True is quite effective on transferring big volumes of data through slow connection. Pay attention that each row is compressed separately. Be careful when setting this option as in some cases it may decrease fetch speed instead of increasing. This property is ignored under CLR. The default value is False.

Write detailed SQL log - You can use this checkbox in case if you need to see all sql .log files which were created by Store Manager during it work.

Table prefix - You need to enter your database prefix for correct work of your Store Manager with current database. You can click at Autodetect button and database prefix will be determined automatically.

Rebuild 'catalog_category_product_index' for entire category tree of a product - This dropdown allow you to affect on reindex your data. You can select one of the following settings for it. 

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