ERROR 2003（HY000）：无法连接到'localhost'上的MySQL服务器（10061“未知错误”）

Question

This may be a duplicate question, however I searched internet for a while, and still couldn't find the solution.

I installed xampp on windows 7. The mysql is running on a random port. However, I can't access mysql from command line. I keep getting this error message:

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error").

I enabled mysql for windows services as administrator, and opened the port that the mysql is using through windows firewall settings. But the problem is still not fixed, and I still can not see the port from http://canyouseeme.org/.

Answer 1

Open a command line with administrative privileges. Type the command below.

netstat -a -p tcp | findstr ":138"

Give it the port number that your sql is using instead of ":138" in the above example. Check if the output contains 0.0.0.0 as the IP or not. If it contains your local area network IP then use that IP to connect. Perhaps MySQL is not using all IPs to listen for connections.