Knowledgebase: MySQL Databases
Database: Whitelist Your IP in cPanel for Remote MySQL Access
Posted by Benjamin Antenor, Last modified by Aaron Eaton on 21 April 2016 03:03 PM

This will show you how to whitelist your IP to allow remote MySQL connections for Shared, Reseller, VPS/cPanel and Linux Dedicated Servers.

Allowing remote MySQL connections is often done to enable a program on your personal computer (such as Adobe Dreamweaver) to access the database on the server.

Allowing remote MySQL connections is often done to enable a program on your personal computer (such as Adobe Dreamweaver) to access the database on the server.

By default, all IPs are blocked and must be added to an access list.  To find our what your own IP address is, go to hostgator.com/ip.shtml (your IP address will be listed in red).

  1. Login to your cPanel (if not already logged in).
  2. Scroll down to the Databases section.
  3. Click on the Remote MySQL icon.
  4. Enter the IP address of the computer that will be making the remote connection.
  5. Click the Add Host button.

How can I find out my computers IP address?

Click this link to view your computer IP Address

What if I got a Dynamic IP address?

If you got a dynamic IP address. Therefore, every time you go online, or every once in awhile, your IP changes. You have a few options here. The most secure, would be to update your IP in Remote MySQL every time your IP changes. However, you do have other options available. You could simply enter % (a percentage sign) in the Add Access Hosts text field. This will allow any IP to remotely connect to your databases. Another option: Lets say the first two parts of your IP never change. Then, you could enter 93.138.%.% , where the first two parts are your actual IP address numbers.

Note: If you're connecting from a dynamic IP address, you can use the "%" wildcard value instead of an IP address.  However, since this will grant access from anywhere, it is generally considered a security risk and therefore not recommended.

Once the enabled remote access is done, You will need a third party application to access MySQL remotely. Some are free and some cost money.

 

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).