1、问题:
公司linux系统的mysql数据库root用户设置过密码,但常常用命令’mysql -u root -p’登录报错,有时又能登录。登录报错信息为:
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES
2、原因:
mysql> select user,host,password from user;
如下:
±-----±----------------------±---------+
| user | host | password |
±-----±----------------------±---------+
| root | % | mima |
| root | localhost.localdomain | mima |
| root | 127.0.0.1 | mima |
| | localhost | |
| | localhost.localdomain | |
±-----±----------------------±---------+
3、解决办法:
mysql> delete from user where user=‘’;
MYSQL ERROR 1045 错误解决办法
于 2022-06-29 13:30:04 首次发布