Remote MYSQL connecton

Updated on 26-Nov-2021 in Web Hosting
735

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

2_6183de4d0f66b_2_1636123177.png

  • Click Add Host to allow the IP

Please note, all databases within the account will be accessible to the IPs added - IP access cannot be added for databases separately.

1 rated the article helpful.

Was this article helpful for you?

Yes No