Title: How to Enable Remote MySQL Access in cPanel
PrimaryCategory: cPanel &amp; WHM Hosting
Type: Procedural
Tags: mysql, remote_access, cpanel, database, security
Source UI Terms: Databases, Remote MySQL, Host, Comment, Add Host, Delete
Source Reference: How to Enable Remote MySQL Access in cPanel

Prerequisites:
- Access to the domain’s cPanel interface with valid login credentials.

Steps:
1) Log in to the domain’s cPanel interface using your valid credentials.
2) Navigate to the Databases section and click on &quot;Remote MySQL.&quot;
3) To allow remote hosts access to your MySQL databases, enter the fully qualified domain name (FQDN), an IPv4 address, or an IPv6 address in the &quot;Host&quot; text box.
4) Optionally, enter a description for the remote host in the &quot;Comment&quot; text box.
5) Click &quot;Add Host&quot; to grant access.
6) To remove access for a host, click the &quot;Delete&quot; link next to the host in the list of Access Hosts.

Warnings:
- Note: Remote MySQL connections are disabled by default for security reasons. Only allow remote access to trusted hosts.

Summary:
To enable remote MySQL access in cPanel, log in, go to Remote MySQL in the Databases section, add the host’s address, and confirm by clicking Add Host. Remove access anytime by deleting the host entry.

Evaluation Pairs:
Q: How do I allow a remote server to access my MySQL database in cPanel?
A: Log in to cPanel, open Remote MySQL in Databases, enter the host&#39;s domain or IP address in the Host field, optionally add a comment, and click Add Host.

Q: Can I remove a remote host’s MySQL access later?
A: Yes, in the Remote MySQL interface, click the Delete link next to the host you want to remove from the access list.

Q: Why is remote MySQL access disabled by default in cPanel?
A: Because allowing remote connections can pose a security threat, so it is disabled by default to protect your databases.

<div dir="ltr">When you want to connect to your MySQL database from outside your hosting server. This article explains how to allow or remove remote MySQL access in cPanel.<br><br>This feature allows remote hosts (servers or web applications) to access MySQL databases hosted on your account because Remote MySQL connections are disabled by default in cPanel servers as they are considered a potential security threat.</div>
<div> </div>
<h2 dir="ltr">Managing Remote MySQL via cPanel</h2>
<div dir="ltr"><br>Following are a step by step guide on how to allow remote access to a MySQL database in your cPanel:</div>
<ol><li dir="ltr">
<div dir="ltr">Log in to the domain’s cPanel interface using valid credentials.</div>
</li><li dir="ltr">
<div dir="ltr">Go to the Databases section and click Remote MySQL.</div>
</li></ol>
<div> </div>
<div><img alt="wse_image1" src="https://assets.resourceserver.org/docs/Screen_Shot_2021-01-28_at_5.51.48_PM.png"></img></div>
<div> </div>
<h2 dir="ltr">To allow remote hosts to access MySQL databases on your account</h2>
<div dir="ltr"> </div>
<ul><li dir="ltr">
<div dir="ltr">Enter the fully qualified domain name (FQDN)/ an IPv4 address/ an IPv6 address in the Host text box.</div>
</li><li dir="ltr">
<div dir="ltr">Enter a description for the remote host in the Comment text box (Optional) and click Add Host.</div>
</li></ul>
<div> </div>
<div dir="ltr"> </div>
<div><img alt="wse_image1" src="https://assets.resourceserver.org/docs/Screen_Shot_2021-01-28_at_5.51.58_PM.png"></img></div>
<div dir="ltr"> </div>
<h2 dir="ltr">To Remove Access Host</h2>
<div dir="ltr"><br>To deny access to a host having access to the databases, click the Delete link from the list of Access hosts. </div>
<div dir="ltr"> </div>
<div><img alt="wse_image1" src="https://assets.resourceserver.org/docs/Screen_Shot_2021-01-28_at_5.52.08_PM.png"></img></div>

When you want to connect to your MySQL database from outside your hosting server. This article explains how to allow or remove remote MySQL access in cPanel.