Store Manager requires direct MySQL database connection. Most of the 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. Access list is a 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 a few steps listed below:
2. Enable Direct connection to remote database check-box.
3. Specify the following Remote Database Connection Settings:
Your server name is defined in configure.php or config.php at the top:
You can find them at the bottom of configure.php or config.php file:
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 list.
Tip: Use the Test Connection button to verify if all settings are correct and connection to your remote database is possible.
Click 'OK' to save this entry, close Preferences 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 selecting the corresponding actions from the drop-down.
If you're unable to connect to remote database, here are a few key items to check.
If you got "SQL ERROR: Access denied for user 'admin'@'194.187.228.147' (using Password: YES)" notification (where 'admin' 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.