On any vanilla cPanel server, the cPanel Remote MySQL allows remote hosts (servers) to access the MySQL databases on your cPanel account.
On Web Hosting Magic, this is not allowed on shared hosting accounts.
Customers wishing to use the Remote MySQL will have to use either a cPanel VPS or a cPanel dedicated server.
If you are a VPS or dedicated customer and want to use this function (perhaps to allow applications on other servers to access your databases), then:
Login to cPanel and scroll to Databases.
Enter the host’s name in the Host text box.
You may also enter a fully qualified domain name (FQDN), an IPv4 address, or an IPv6 address.
You may use the percentage sign character ( % ) as a wildcard.
For example, to allow access from all IP addresses that begin with 192.68.0, enter 192.68.0%.
Enter a description for the remote host in the Comment text box.
You must limit this description to 255 ASCII characters or fewer.
Click Add Host.
To edit the description for a remote host, enter the new text and click Update.
A message of success will appear.
If you change your mind later and want to deny database access to a remote host:
Click Delete next to the host’s name or IP address.
A confirmation message will appear.
Click Remove Access Host.
A message of success will appear.
