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

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

Testing your Connection