cPanel Remote MySQL and Web Hosting Magic

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.

 

  • Database, MySQL, PostgreSQL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How To Resolve The "Incorrect Format Parameter" In phpMyAdmin

If you are trying to import a database and meet the "Incorrect Format Parameter" error, it might...

Here Is The Correct Way To Create A Database In cPanel

We recommend that you do not use phpMyAdmin to create databases or database users. We suggest...

How To Use Database Wizard To Create A Database In cPanel

The cPanel MySQL Database Wizard is designed to guide you through the setup of a MySQL® database,...