Adding host access
To add remote host access for MySQL, follow these steps:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click Remote MySQL.
- Under Add Access Host, in the Host text box, type the domain name or IP address of the host that you want to add.
- In the Comment text box, you can add an optional comment to describe the remote host.
- Click Add Host.
Accessing your database remotely
After you enable host access, you can connect to your MySQL databases remotely by using a MySQL client application. For more information about how to use MySQL client applications, please see this article.
Removing host access
You can remove host access when you no longer want a host to be able to access your MySQL databases remotely.
To remove host access, follow these steps:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click Remote MySQL.
- Under Manage Access Hosts, locate the host for which you want to remove access, and then click Delete.
- Click Remove Access Host. cPanel removes the host.