Remote MySQL Connection Issue

[GodLumeN]

Hello,
I have somes troubles with the remote SQL link between my Cpanel and a remote script. So I have two servers a VPS is CPanel under centos 6 and the dedicated where is my script under debian 9 of the coup I "whitelist" the ip of the dedicated on WHM and CPanel but unfortunately the connection is not done in the SQL logs I see connection dead.
And I have verified that the password and the identifier and that the database name is correct.

 

[Eminds]

Go through the below link , it might help you

Remote MySQL - Version 76 Documentation - cPanel Documentation

 

[GOT]

You also need to add the IP of the debian server to the remote Mysql Hosts either in the account cpanel where the database is, or in WHM to cover the entire server.

 

[cPanelLauren]

Hi @GodLumeN


The suggested provided in here are both great, if you could please go through the steps listed in the documentation provided and let us know if you're still experiencing issues.

Thanks!

 

[GodLumeN]

I allready do this step Remote MySQL - Version 76 Documentation - cPanel Documentation
and I added the IP on WHM too

 

[GodLumeN]

This is the error: This is the error: ERROR 2003 (HY000): Can't connect to MySQL server on 'xx.xx.xx.xx' (111 "Connection refused")

 

[GodLumeN]

I found the issue,

in /etc/my.cnf i had to remove bind-address=127.0.0.1

 

[cPanelLauren]

Hi @GodLumeN

I'm really glad to hear you were able to identify the cause of the issue! Thanks for letting us know.