This article describes how to use cPanel to allow external hosts to access your MySQL databases. When remote host access is enabled, you can use remote client applications to connect to your databases directly.
- Login to cPanel.
- In the DATABASES section of the cPanel home screen, click Remote MySQL
- Under Add Access Host, enter the hostname or IP address that you want to grant remote MySQL access to and click the Save button. If your IP address changes regularly, you can use wildcard by using the % symbol. This will add all IP addresses in that range. For example; if you want to list IP addresses range from 192.168.3.1 to 192.168.3.255, you can add an IP address as 192.168.3.%.
Now, since you have added the IP address to remote MySQL connections you will be able to connect to the databases. You can add as many IP addresses as you need.
Having a dynamic IP address means that the connecting IP address can change periodically, depending on the Internet Service Provider (ISP). You must update the connecting IP in Remote MySQL every time it changes.