Knowledgebase

Remote MySQL allows you to use a MySQL server on a different machine to hold your databases. This can be extremely useful when your databases are large or this server has high load.

NOTE: Remote MySQL is not how you can connect to a MySQL Database from a server or workstation. To connect to a MySQL Database remotely, you need to add privileges to that database using MySQL's GRANT function: http://dev.mysql.com/doc/refman/5.0/en/grant.html

Steps

1. To access the SQL Services Menu, click on SQL Services, on the main screen of your WebHost Manager interface.
2. Click on Setup Remote MySQL Server.
3. Enter the Name of The Remote server in the Remote MySQL Host Field and it's password in the Remote Mysql Host's Root Password Field.

NOTE: Do not enter the root password for the remote MySQL server in the Remote MySQL Host's Root Password Field.

1. Click on Setup.

Add to Favourites

Print this Article