MySQL Remote Access

There may be times when you have to connect to the database from outside your work network and if that's the case, you need to connect to your database using third party software that does not run on the server (i.e. a MySQL client on your desktop). This is referred to as making a remote MySQL connection. To do this, however, you will first have to allow the connection from within cPanel for the IP address you are connecting from. Read on to learn how.

Adding an IP address to allow a remote MySQL connection

First, you will need to make sure you have the IP address that will be accessing the database. These rules protect the database by only accepting external connections that you have set up. If you are connecting to a database from your current connection, get your IP address by clicking here, then follow these steps:

  1. Log into your cPanel web hosting control panel.
  2. Click the Remote MySQL button in the Databases section.
  3. Enter your IP address in the Add Access Host section.
  4. Click the Add Host button. You will then see a message stating the host IP address was added to the access list.

Using a Wildcard to add a range of IP Addresses

You may find you need to use a wildcard if your IP address changes regularly. You can add a wildcard by using the % symbol. This will add all IP addresses in that range. For example, if you want to list all IP addresses in the range 174.77.92.1 to 174.77.92.255 you'd add the IP address 174.77.92.%.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Seeing list of files, not home page

Like all linux-based web servers, your 'home page' must be named index.htm or index.html,...

Add-on Domains

Most of our web hosting packages allow you to have multiple domain names. The additional domains...

Parked Domains

Most of our web hosting packages allow you to have multiple domain names. The additional domains...

Setup E-mail Forwarding

The process of setting up e-mail forwarding depends on whether you are using the free e-mail...

Get Web Hosting and EMail Instructions resent to you

When you first signed up for Web Hosting service with QTH.com, you would have received an email...