Adding MySQL access hosts

[VelMurugan]

Adding MySQL access hosts

You can allow access to MySQL databases from an external location by adding its domain name or IP address to the list of hosts that are allowed to access your databases remotely. Additionally, if you would like to manage your database using an application for remote database management, the IP address from which the connection is established should be added to the list of allowed hosts.

In order to add allowed hosts you should access the tool via cPanel -> Remote MySQL:

cPanel -> Remote MySQL

In the Host field you should enter the desired domain name or IP address:

Enter the domain name or IP address

Click on the Add host button.

A confirmation message will inform that the host is successfully added. Next time you access Remote MySQL the newly added host will be listed under Access Hosts.

Source : siteground