Database connection: Direct, Bridge, Direct Connection through HTTP Tunnel. What is the difference?

Database connection: Direct, Bridge, Direct Connection through HTTP Tunnel. What is the difference?

To start working with your store first of all you have to select what type of connection you would like to set-up. Currently Store Manager allows to set-up:
  1. Direct Connection
  2. Bridge connection
  3. Store Manager Connector
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. If direct connections are not allowed there is another way - secure SSH connection. Actually SSH is a kind of tunnel between two computers - your and your server. Other connections can be established via SSH tunnel. You can use SSH for MySQL as well as for FTP connections. See "Preferences" window, "SSH" page. The only info you need is SSH user namepassword and remote port number - basically the same as for typical MySQL connection. Note: SSH settings do not override MySQL settings. To connect to your database using SSH you must specify all required MySQL parameters as well as SSH. PHP-MySQL bridge connection. If no direct MySQL nor SSH connection is possible or you getting frequent "Connection lost" events try PHP-MySQL bridge connection. Store Manager Connector. Store Manager allows to set-up Store Manager Connector as an alternative way of connecting to your database. This type of connection works the same way as Bridge only with the help of module that has to be installed in your backend.
Important note: In Store Manager for Magento and Store Manager for Prestashop the number of Store connections depends upon the edition.
Please, check the link for more details for Magento:
www.mag-manager.com/store-manager-for-magento-plans-and-pricing
for Prestashop:
www.prestashopmanager.com/order/
Thus to manage more than one store, you need to upgrade to PRO Edition. Click here to find out how to upgrade.