Whitelist Your IP in cPanel for Remote MySQL Access

Remote MySQL access allows applications or services hosted outside your server to connect directly to your MySQL database. This is useful for database management tools, development environments, and third-party applications that require remote database connectivity.

For security reasons, remote connections are blocked by default on Shared, Reseller, VPS, and Dedicated hosting accounts. To permit a connection, you must add the external IP address to the Remote Database Access list in cPanel. This guide explains how to whitelist an IP address, discusses options for users with dynamic IP addresses, and provides guidance on connecting to your database once remote access has been enabled.

How to whitelist an IP

Log in to cPanel.
Go to the Databases section and click on the Remote Database Access icon.
Under Host, enter the computer's IP address that will be making the remote connection.
Click the Add Host button.

How can I find out my computer's IP address?

To find your computer's IP Address, use Google to search for 'what is my IP' or go to https://www.google.com/search?q=what+is+my+ip. Google will display your IP Address in the search results. Please note this feature is only available in English.

Wait a minute; my IP constantly changes.

Okay, you have a dynamic IP address. Therefore, your IP changes every time you go online or once in a while. You have a few options. The most secure way would be to update your IP in Remote MySQL every time your IP changes. However, you do have other options available. You could enter % (a percentage sign) in the Add Access Hosts text field. This will allow any IP to connect to your databases remotely. Another option: Let's 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 anywhere, it is generally considered a security risk and therefore not recommended.

I enabled remote access; now what?

You will need a third-party application to access MySQL remotely. Some are free, and some cost money. For a list of applications, you may want to visit our page:

Managing Your Database with Applications

How can we help you? Please contact us via phone or chat if you need assistance.

Did you find this article helpful?