Remote MySQL Connection Issue

GodLumeN

Member
Feb 6, 2019
5
0
1
France
cPanel Access Level
Root Administrator
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.
 

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,740
300
363
Chesapeake, VA
cPanel Access Level
DataCenter Provider
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

Product Owner
Staff member
Nov 14, 2017
13,304
1,250
313
Houston
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!