Troubleshooting remote connection to MySQL

microvax

• April 29, 2021 09:03

Hello, I have enabled remote MySQL connection to one customer's CPanel account for an external developer, however he is telling me that he can't connect, despite having added this IP to the server whitelist. Is there a place where I could see the MySQL log files in order to find failed connections?

• 

  cPDavidL

  • April 29, 2021 15:06

  Hello! The MySQL error logs should be in /var/log/mysqld.log or /var/lib/mysql/$hostname.err(where $hostname is the system hostname). If the client is failing to establish a connection at all, you'll want to check for network connections when they try access. This can be done with netstat, and if necessary tcpdump With netstat, have the user try to log in, and immediately run: netstat -anp | grep $usersIP (set $usersIP as the IP they are connecting from) Look to make sure the connection is reaching the OS. If not, then check for firewall and/or network issues.

  0
• 

  stephenpl

  • April 30, 2021 14:50

  Does 3306 need to be open on CSF or is whitelisting the IP address enough?

  0
• 

  cPRex Jurassic Moderator

  • May 03, 2021 19:01

  I would expect that 3306 needs to be open for that connection to work properly.

  0

Please sign in to leave a comment.