Setup Remote MySQL Server

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.
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

List Accounts

The List Account function displays all of the accounts on your server. It displays a variety of...

List Parked Domains

This function displays all domains that are parked on top of another domain. For more information...

List Subdomains

WebHost Manager enables you to list all subdomains on your server. This function will display all...

List Suspended Accounts

This function allows you to list all the accounts that have been suspended on your server. Steps...

Show Accounts Over Quota

This function allows you to list all of the accounts on your server that have exceeded their disk...

Powered by WHMCompleteSolution