fmPreferences - fmDirectConnection
Store Manager 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:
Also you can use Database Connection Wizard to setup your connection.
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'@'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.