Knowledgebase: MySQL
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: example_mydb 
   database user: example_dbuser
   IP address given to your computer from your ISP: 1.2.3.4 (get the IP of your computer here)
   server name: server.asmallorange.com (get the IP of your server here)

Access Hosts

  1. Log in to cPanel and click MySQL Databases
  2. Scroll down to Access Hosts
  3. Enter your IP address (eg, 1.2.3.4) in the field next to Host (% wildcard is allowed): 
  4. Click Add Host
  5. You can enter something like 1.2.3.% if you want to allow a range if IP addresses
    Note: this is not safe; it will allow anyone in that entire network range to have access to your database if they are able to obtain your password.

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 Database

Currently, the database user only has access through localhost, so you need to force it to recognize the IP address.
  1. Scroll up to the Current Databases and look for the database 'example_mydb'
  2. You'll see two delete buttons, one next to the database name (example_mydb) and one under that next to the username (example_dbuser).
  3. Click the Delete next to the database username

    The next screen says:
    Account Removed from Access List
    Deleted the user example_dbuser from the database example_mydb. 

Add User to Database

  1. Scroll back down to Add Users to Your Databases
  2. Select the user 'example_dbuser' from the dropdown menu on the left and the database 'example_mydb' from the dropdown menu on the right.
  3. Click Add User to Database

Testing your Connection

Now, 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.
(7 vote(s))
This article was helpful
This article was not helpful

Comments (2)
Marcus Wilson
07 September 2012 09:01 AM
Although my problem wasn't solved it did direct me to some useful information.
Brent S. (ASO)
09 September 2012 05:12 PM
Marcus, if you still need any further help feel free to open a ticket. Thanks, and glad we could inform!
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako fusion