---
title: How to Enable Remote MySQL Connections in WHM and cPanel
description: "**In short:** To allow connections to a MySQL database from an external server or computer: in WHM, go to SQL Services, then Additional MySQL Access Hosts, and add the allowed IP address. Then in cPanel, go to Databases, then Remote…"
url: "https://www.hyyat.com/en/knowledgebase/enable-remote-mysql/"
updated: "2026-09-29"
category: Server management / whm/cpanel control panels
---

# How to Enable Remote MySQL Connections in WHM and cPanel

**In short:** To allow connections to a MySQL database from an external server or computer: in WHM, go to SQL Services, then Additional MySQL Access Hosts, and add the allowed IP address. Then in cPanel, go to Databases, then Remote MySQL, and add the same address. Only allow specific IP addresses; do not use %, which opens your databases to everyone.

By default, remote MySQL connections are disabled on cPanel servers. You need them when an application or website on another server connects to your database, or when you manage the database from a program on your computer such as MySQL Workbench or HeidiSQL. Only allow specific, trusted IP addresses, because opening databases to everyone is a serious security risk.

## In WHM (server administrators)

**1.** Log in to WHM at **https://your-server-ip:2087** with your username and password.

![WHM login](https://www.hyyat.com/wp-content/uploads/2018/04/whm.png)

**2.** Go to **SQL Services**.

![SQL Services](https://www.hyyat.com/wp-content/uploads/2019/04/Remote-MySQL.png)

**3.** Click **Additional MySQL Access Hosts**.

![Additional MySQL Access Hosts](https://www.hyyat.com/wp-content/uploads/2019/04/Remote-MySQL2.png)

**4.** Enter one or more hostnames or IP addresses and click **Save**. To apply them to all accounts, use the link on the same page.

![Add access hosts](https://www.hyyat.com/wp-content/uploads/2019/04/Remote-MySQL1.png)

## In cPanel (each account)

**1.** Log in to cPanel (see [how to log in to cPanel](https://www.hyyat.com/en/knowledgebase/how-to-log-in-to-cpanel/)).

**2.** In the **Databases** section, click **Remote MySQL**.

![Remote MySQL](https://www.hyyat.com/wp-content/uploads/2019/04/Remote-MySQL33.png)

**3.** Add the hostname or IP address you want to allow and click **Add Host**. To remove one later, click **Delete** next to it.

![Add access host](https://www.hyyat.com/wp-content/uploads/2019/04/Remote-MySQL4.png)

Connect using your server hostname or IP as the host, port 3306, and the database user and password you created in cPanel.

**Related service:** [Hyyat Host server management](https://www.hyyat.com/en/server-management/) can set up secure database access for you, with 24/7 support.

 **Need this service from Hyyat Host?**Our team handles it for you, with support replying to tickets within 24 hours at most.[Server Management](https://www.hyyat.com/en/server-management/)[dedicated server](https://www.hyyat.com/en/dedicated-server/)