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.
  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Add A DNS Zone

A DNS zone is a part of your domain name but it may contain different DNS information. For...

Add A New IP Address

WebHost Manager enables you to add a new IP address at any time, along with the address's...

Add An A Entry For Your Hostname

An A entry is an Address entry, and can be entered at any time for your hostnames. Do...

Add Packages

Packages allow you to create accounts with a preset amount of disk space, bandwidth, e-mail...

Add Reseller Accounts

A reseller account will have the ability to create other accounts on your server. Accounts...