You can set up remote MySQL to connect to your databases remotely. It will allow the connection to all of your databases while still requiring username and password authentication for that specific database you are connecting to.
To enable it, follow these steps:
Access your cPanel and navigate to the Remote MySQL menu in the Databases section:
Next, fill in the IP address from which the remote connection will be initiated on the Host field. To alllow connections from any IP, enter the percent % symbol. Optionally, you can add a description for the remote host in the Comment field. When ready, click on Add Host:
Most servers use load balance, so it may happen that the request will come from different IPs. Therefore, it is recommended to use the wildcard option (%). For security, you will be still required to authenticate using the database username and password.
That's it, the newly added host will appear on the Manage Access Hosts section:
Remote connections also require you to specify a MySQL server hostname - use the value of your hosting IP address 💡