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,161,547 views tags: connection database mysqlfront remote

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

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

Related Help Content

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

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

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

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

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

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

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

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