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
- To access the SQL Services Menu, click on SQL Services, on the main screen of your WebHost Manager interface.
- Click on Setup Remote MySQL Server.
- 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.
- Click on Setup.