HostGator Web Hosting Help

Whitelist IP Address

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. Log in to your HostGator cPanel account.
  2. Click 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: You may visit HostGator.sg/ip to find your IP address. 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.*).


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

How do I remotely connect using a database management software?
Knowledgebase Article 1,178,283 views tags: connection database mysqlfront remote

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin
Knowledgebase Article 199,052 views tags: databases mysql phpmyadmin

Guidance on adding tables to your mySQL database in phpMyAdmin
Knowledgebase Article 114,332 views tags: mysql phpmyadmin

Related Help Content

How to Restore your MySQL Database?
Knowledgebase Article 383,861 views tags: admin database mysql php phpmyadmin restore

A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin
Knowledgebase Article 188,464 views tags: Plesk cpanel databases mysql phpmyadmin

How do I import a backup of my database (.sql file) using phpMyAdmin?
Knowledgebase Article 781,628 views tags: database mysql phpmyadmin

A guide to duplicating a MySQL database using phpMyAdmin
Knowledgebase Article 242,671 views tags: databases mysql phpmyadmin

A repository of information on how you can manage your database by using the phpMyAdmin interface.
Knowledgebase Article 375,456 views tags: commands database mysql phpmyadmin

This article will show you how to rename a database table in phpMyAdmin.
Knowledgebase Article 322,391 views tags: databases mysql phpmyadmin

A guide on performing a standard SQL query using the phpMyAdmin interface
Knowledgebase Article 191,558 views tags: databases mysql phpmyadmin

Step by step directions on how you can search your database using phpMyAdmin
Knowledgebase Article 184,871 views tags: Plesk cpanel databases mysql phpmyadmin