cPanel and MySQL Access Hosts
Posted by on 13 June 2012 05:00 PM
Let's say you're developing a script on your PC at home, and you need to connect to your database remotely using a MySQL admin program. No problem. This procedure is a little quirky, but here are the steps to grant remote access to your database.|
Note: if you don't have a database yet, start here.
We'll assume you are using the following information:
database user: example_dbuser
IP address given to your computer from your ISP: 22.214.171.124 (get the IP of your computer here)
server name: server.asmallorange.com (get the IP of your server here)
Notify Us of IP
We take MySQL security very seriously, so in addition to the standard cPanel procedure we also need to add the remote IP to the firewall. Please contact Support and notify us of the IP address so that we can make sure it has access to MySQL.
Remove User from DatabaseCurrently, the database user only has access through localhost, so you need to force it to recognize the IP address.
Add User to Database
Testing your ConnectionNow, using your PC and remote MySQL client, enter the connection information for your database, database user, and the server name or IP address.
If you run into problems with any of this, double-check the steps above or send in a support ticket for assistance.