> ## Documentation Index
> Fetch the complete documentation index at: https://kb.hosting.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Configuring remote MySQL access in cPanel

> Learn how to configure cPanel to allow external hosts to access your MySQL databases, which can be used to grant remote access to your databases directly.

This article describes how to use cPanel to allow external hosts to access your MySQL databases. When remote host access is enabled, you can use remote client applications to connect to your databases directly.

<Warning>
  **Important**

  * Enabling direct remote access to your databases is a potential security risk. An alternative, more secure way to access your databases remotely is to tunnel MySQL connections over SSH. For information about how to set up an SSH tunnel for MySQL, please see [this article](/docs/remote-mysql-connections).

  * **Any** application using TCP/IP to connect to a MySQL database must have its IP address whitelisted in the cPanel Remote MySQL tool. This includes connections that use the local loopback address ( **127.0.0.1** ).
</Warning>

## Adding host access

To add remote host access for MySQL, follow these steps:

1. Open a support ticket on the hosting.com Hosting Panel at [https://my.hosting.com](https://my.hosting.com). In the ticket, specify that you want to enable inbound access to MySQL port 3306 for your account.

2. You will receive confirmation from hosting.com Support that MySQL access is configured for your account. Log in to cPanel.
   > 📘 Note
   >
   > If you do not know how to log in to your cPanel account, please see [this article](/docs/accessing-cpanel).

3. On the **Tools** page, in the **Databases** section, click **Remote Database Access**:\
   ![cPanel - Databases - Remote Database Access icon](https://static.hosting.com/kb/kb-cpanel-120-databases-remote-database-access-icon.png)

   > 📘 Note
   >
   > If you are using cPanel version 118 or earlier, click **Remote MySQL** instead:\
   > ![cPanel - Databases - Remote MySQL icon](https://static.hosting.com/kb/kb-cpanel-jupiter-databases-remote-mysql-icon.png)

4. Under **Add Access Host**, in the **Host** text box, type the domain name or IP address of the host that you want to add.
   > 👍 Tip
   >
   > * To obtain your own IP address, use your web browser to visit [http://ipfinder.us](http://ipfinder.us).
   >
   > * If you are adding access for the local loopback address, make sure you type `127.0.0.1`. Do not type `localhost`.

5. In the **Comment** text box, you can add an optional comment to describe the remote host.

6. Click **Add Host**.

## Accessing your database remotely

After you enable host access, you can connect to your MySQL databases remotely by using a MySQL client application. For more information about how to use MySQL client applications, please see [this article](/docs/mysql-client-applications).

## Removing host access

You can remove host access when you no longer want a host to be able to access your MySQL databases remotely.

To remove host access, follow these steps:

1. Log in to cPanel.
   > 📘 Note
   >
   > If you do not know how to log in to your cPanel account, please see [this article](/docs/accessing-cpanel).

2. On the **Tools** page, in the **Databases** section, click **Remote Database Access**:\
   ![cPanel - Databases - Remote Database Access icon](https://static.hosting.com/kb/kb-cpanel-120-databases-remote-database-access-icon.png)

   > 📘 Note
   >
   > If you are using cPanel version 118 or earlier, click **Remote MySQL** instead:\
   > ![cPanel - Databases - Remote MySQL icon](https://static.hosting.com/kb/kb-cpanel-jupiter-databases-remote-mysql-icon.png)

3. Under **Manage Access Hosts**, locate the host for which you want to remove access, and then click **Delete**.

4. Click **Remove Access Host**. cPanel removes the host.

## Related articles

* [Remote MySQL connections](/docs/remote-mysql-connections)

* [MySQL client applications](/docs/mysql-client-applications)

* [Managing MySQL databases and users](/docs/managing-mysql-databases)

* [Accessing phpMyAdmin and phpPgAdmin](/docs/phpmyadmin-and-phppgadmin)

* [Managing MySQL databases, users, and tables from the command line](/docs/managing-mysql-databases-and-users-from-the-command-line)