首页 > 数据库 >ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

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

时间:2023-01-13 15:38:31浏览次数:37  
标签:... 10061 ERROR 端口 HY000 MySQL 3307 port


执行命令:mysql -u root


出现如下错误:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)


解决方法:

查看my.ini文件,看以下配置项是否正确:
[client]
port=3306
...

[mysqld]
port=3307
basedir="F:/.../MySQL"
datadir="F:/.../MySQL/data"
...
-----------------------------------------------------------


错误原因是端口不一致?:
[client]
port=3306
...


[mysqld]
port=3307


将这两个端口改成一样的就可以了。。。

或者指定端口登录:mysql -u root -p 123 -P 3307 -h192.168.0.100 









标签:...,10061,ERROR,端口,HY000,MySQL,3307,port
From: https://blog.51cto.com/softo/6006057

相关文章