本文介绍了当遇到MySQL连接错误2003（HY000）时，如何排查和解决问题。通过查看错误代码111，发现是连接被拒绝。经检查，本地MySQL可能并未运行在默认端口3306上。不指定IP地址的连接实际上是通过socket方式，而TCP/IP连接需要明确指定IP和端口。通过`mysql -h127.0.0.1 -uroot -p --port=实际端口`命令可以成功连接到正确的MySQL服务。
[root@localhost bk]# mysql -h127.0.0.1 -uroot -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
[root@localhost bk]# perror 111
OS error code 111: Connection refused
[root@localhost bk]#
#去掉ip地址能登录
[root@localhost bk]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.35-log MySQL Community Server (GPL)
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
原因
--尝试下来，port问题，有可能本地的MySQL port不是默认3306，这样(mysql -h127.0.0.1 -
最低0.47元/天 解锁文章
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
