Remote MySQL Connection Issue

GodLumeN

• February 07, 2019 22:48

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

  • February 08, 2019 10:42

  Go through the below link, it might help you Remote MySQL - Version 76 Documentation - cPanel Documentation

  0
• 

  GOT

  • February 08, 2019 12:57

  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.

  0
• 

  cPanelLauren

  • February 08, 2019 17:48

  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!

  0
• 

  GodLumeN

  • February 09, 2019 08:08

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

  0
• 

  GodLumeN

  • February 09, 2019 15:48

  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")

  0
• 

  GodLumeN

  • February 09, 2019 16:23

  I found the issue, in /etc/my.cnf i had to remove bind-address=127.0.0.1

  0
• 

  cPanelLauren

  • February 11, 2019 13:57

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

  0

Please sign in to leave a comment.