Duration for this tutorial of allowing remote access to MySQL in cPanel is 10 minutes.
Sometimes when you have created a new user for your database, e.g. developer needs access to the staging database, you also need to allow remote connection to the same database. This short “How-To” by BestCloudTools gives you a quick overview of how to allow remote access to MySQL database in cPanel.
- Navigate to “Remote MySQL®” view to allow remote connection to database in cPanel
Please search for „Remote MySQL®“ on the Database section and click on it.
- Insert host address(es) and click on “Add Host” to allow remote access to the database
Here we add IP addresses from where we would like to allow remote connections. Jump to Google and type in “What is my IP address“ and you will find an online service that performs the job for you. Now we can whitelist the address where you would like to allow connections. There are several choices like you may enter a fully qualified domain name (FQDN), an IPv4 address, or an IPv6 address. You can use a percentage sign character (%) as a wildcard. For example, to allow access from all IP addresses that begin with 177.69.0, enter 177.69.0%. Click on “Add Host” to allow remote access to MySQL in cPanel. When facing any problems you can take a peek to corresponding cPanel docs.
Still something unclear? Don't hesitate to contact me or please let me know if you find any misleading instructions!