How to Enable Remote MySQL Connection in WHM?

Steps to enable MySQL connection

1) Login to WHM server.

2) Go to the ‘SQL Services’ section and find the option ‘Additional MySQL Access Hosts’.

3) Input the IP or hostname from which you want to remotely connect to the MySQL server in the provided text box.

4) Click the ‘Save’ button to apply the changes.

5) To enable remote MySQL connection for all cPanel users, use the ‘Click here’ option.

Allowing remote host IP in server firewall

1) Login to your server using SSH.

2) Use the following command to whitelist the remote IP in the csf firewall:

# csf -a <IP>

3) Restart csf to enable the changes.

# csf -r

Steps from WHM:

1) Login to WHM.

2) In the ‘Plugins’ section, find and click on ‘ConfigServer Security & Firewall’.

3) To whitelist an IP address in the csf.allow file, enter the IP that you want to whitelist in the ‘Quick Allow’ section along with a comment explaining the allow action.

4) Click the ‘Quick Allow’ button to save the changes.
Enabling MySQL remote connections from cPanel

1) Log in to your cPanel interface.

2) Navigate to the ‘Databases’ section and locate the ‘Remote MySQL’ icon.

3) Enter the desired remote host name or IP address in the provided text box.

4) Click the ‘Add Host’ button to add the IP to the remote host list.

Now you can log in to the remote MySQL server from the allowed host in the WHM server.