In order to connect MYSQL database remotely (on local machine or other servers), you are required to add IP to the allowed list. By default cPanel will only allow databases connectivity from within the server (for security).

In order to connect MYSQL databases remotely, please follow the steps below:

• Login to cPanel
• Go to Remote MySQL option

• Put in the IP address in the Add Access Host, optional comments can be added for reference

• Click Add Host to allow the IP