Can't connect to MySQL server on 'localhost' (10061)解决_MySQL
程序员文章站
2022-05-10 16:21:32
...
bitsCN.com
Can't connect to MySQL server on 'localhost' (10061)解决方案
0:前言
mysql用SQLyog或者navicat连接不上数据库
重启服务器还是连不上
用cmd方式能够登陆mysql
1:解决方案
host文件(host文件在C:/WINDOWS/system32/drivers/etc目录下)中添加
[html] 127.0.0.1 localhost
打开my.ini,在[mysqld]添加
[html] bind-address = 127.0.0.1
重启mysql
bitsCN.com
推荐阅读
-
Linux登录MySQL时出现 Can't connect to local MySQL server through socket '/tmp/mysql.sock'解决方法
-
解决MYSQL出现Can''t create/write to file ''#sql_5c0_0.MYD''的问题
-
解决MYSQL出现Can''t create/write to file ''#sql_5c0_0.MYD''的问题
-
连接Mysql提示Can’t connect to local MySQL server through socket的解决方法
-
解决MYSQL出现Can''t create/write to file ''#sql_5c0_0.MYD''的问题
-
MYSQL ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.10.210' (111) 解决方法
-
MySQL连接错误:Can't connect to MySQL server on'localhost' (10055)
-
MySQL错误 ERROR 2002 (HY000): Can't connect to local MySQL server through socket 的解决办法
-
windows 连接 linux 上的mysql出现Can't connect to; is not allowed to connect;Access denied for user
-
解决MYSQL出现Can''t create/write to file ''#sql_5c0_0.MYD''的问题