登录失败信息:
ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: YES)
解决方案:
使用root用户登录mysql
执行sql语句:
delete from mysql.user where User="";
flush privileges;
原因:
mysql.user表中存在用户名为空字符串的用户(匿名用户,用户名和密码都为空),影响了普通用户的登录。
mysql> select User,Host from mysql.user;
+------+-----------+
| User | Host |
+------+-----------+
| test | % |
| root | 127.0.0.1 |
| | centos |
| root | centos |
| | localhost |
| root | localhost |
+------+-----------+
6 rows in set (0.00 sec)
把匿名用户删除之后,普通用户就可以正常登录了。
原文:https://blog.csdn.net/MasterDarker/article/details/82789476