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

[Nycest]

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]

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.

 

[Nycest]

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

 

[cPRex]

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.