Error in getting data2003 (HY000): Can't connect to MySQL server on '****:3306' (10060)

Nycest

• August 20, 2023 10:08

Hello everyone, I have been working with remote MySQL successfully, just yesterday I couldn't access the database anymore. I keep getting this error anytime I try connecting Error in getting data2003 (HY000): Can't connect to MySQL server on '****:3306' (10060) Please I really need help as I can't seem to find anything on google that's helping, thank you.

• 

  cPRex Jurassic Moderator

  • August 21, 2023 16:54

  Hey there! Whenever there is a connection issue like this, the first thing to try is to disable the firewall on the system temporarily and see if that resolves the problem. Can you test that? You could also try a basic telnet test to confirm the connection works. You can run this from the command line of the server: telnet hostname.domain.com 3306 where the "hostname" section is whatever connection string is being used in MySQL.

  0
• 

  Nycest

  • August 22, 2023 09:20

  Hello cPRex, I have disabled firewall and it still shows the same error, I used the telnet method, but I am a bit confused with the MySQL connection string you highlighted as hostname, I am not really getting the idea, kindly elaborate, thank you

  0
• 

  cPRex Jurassic Moderator

  • August 22, 2023 09:25

  The "telnet" command is just a way to test a connection. For example, if I wanted to see if the webserver port of 80 was open on the machine with an IP of 1.2.3.4 I would run this: telnet 1.2.3.4 80 If I can connect from my location, I'll get some type of output from that test. Performing this test is a quick way to determine if there is a port or network issue for an application.

  0

Please sign in to leave a comment.