
mysql--bug
楠哥学IT
一心想为IT行业添砖加瓦,却总是面向cv编程的程序员
展开
-
Access denied for user ‘root‘@‘localhost‘ (using password: YES) 拒绝访问错误
错误如图所示: 解析错误:ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES);: ①Access denied(拒绝访问); ②using password:NO/YES解决方案:(1)到安装的MySQL的目录(例如:D:\mysql5\mysql-5.7.31-winx64)下,找my.ini文件;(2)在[mysqld]后添加skip-grant-tables(使用原创 2020-09-02 00:17:07 · 664 阅读 · 0 评论 -
ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)解决办法。出现这个错误的原因有两个:第一种:mysql服务未正常运行mysql服务未正常运行:执行命令:service mysqld status之后执行命令:service mysqld start再次进入bin目录下执行mysql -u root -p就ok了第二种:socket文原创 2020-08-20 22:55:41 · 265 阅读 · 0 评论