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
Please note, all databases within the account will be accessible to the IPs added - IP access cannot be added for databases separately.
- 0 Users Found This Useful
-
How to install Wordpress in cPanel?
Hostcity makes it easy to install and backup Wordpress from within cPanel. All our hosting plans...
How to create emails in cPanel?In order to create email accounts in cPanel, follow the steps below: Login to cPanel Go to...
How to configure redirects in cPanel?URL redirects are configured to direct users to another URL or web page. The functionality...
How to create subdomain in cPanel?Creating subdomains in cPanel is a breeze, you can setup subdomains within few clicks following...
How to add TXT, MX, CNAME & A record in cPanel?cPanel makes it easy to update TXT, MX, CNAME & A records from within its account area. In...
