How do I Whitelist my IP Address? I can't log into MySQL from a remote computer using a MySQL admin tool (phpMyAdmin, Navicat, MySQLFront, MySQL-Admin, etc).

Our firewall automatically blocks remote MySQL connections from remote locations (anything other than localhost), unless the IP address is whitelisted.

To add your IP address to the MySQL whitelist:

  1. Login to your cPanel
  2. Click on the remote MySQL icon under the Databases category
  3. Click the [add] link next to your IP address is: OR type in your IP address (or class C address) and click the add button

Note: The 'Class C' Address means you will whitelist all IP addresses under the first three octets of the IP address (ie: everything under 192.168.0.*).

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What version of MySQL are you running?

The current version can be viewed in the cPanel on left side.

I can't connect to my database locally or remotely, do I have the correct server, username and password?

Since we run a shared hosting environment, we have to uniquely identify your MySQL Users to your...

How do I create an empty MySQL Database

To create the database, do the following: Log into the cpanel Click the MySQL Databases icon...

How do I create a MySQL backup?

There are three options available to backup your MySQL databases: 1) Use the backup utility in...

I need to Export or Import a MySQL database

Note: PhpMyAdmin can only import and export databases up to 50 MB in size. If your database is...