mysql链接错误号码2003,错误号2003。无法连接到MySQL服务器

I has had two days searching and exploring solutions regarding the error 2003.

Can't connect to mysql server on 'Server name'.

The firewall is off and I had added the port 3306, the one that mysql uses.

Any recommendation?

解决方案

Error No. 2003: Can't connect to MySQL server on 'localhost' (or some other host)

simply means that connection is not possible for one of the following (or similar) reasons:

There is no MySQL server running at the specified host

Connection to the MySQL server is not allowed using TCP-IP. Check the 'skip-networking' setting in the MySQL configuration file (my.ini on Windows, my.cnf on Unix/Linux). It shall be commented out like '#skip-networking'. If it is not commented out, then do it and restart the MySQL server for the change to take effect. SQLyog needs to connect using TCP-IP.

Some networking issue prevents connection. It could be a network malconfiguration or a firewall issue.

When trying to connect to a MySQL server at an ISP this error message often indicates that direct connection to MySQL has been blocked. You must then use HTTP-tunneling or SSH-tunneling to connect.