ERROR 1045 (28000)
2018-08-21 本文已影响0人
帕博雷克斯丢丢
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
1:
事件：
删除用户bank@localhost并退出后，登录其他账户会报此错误；
在删除bank用户前后都执行了flush privileges进行权限刷新。
mysql> drop user bank@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
Bye
PS C:\Users\Administrator> mysql -u mysql -p
Enter password: ****
ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: YES)
PS C:\Users\Administrator> mysql -u root -p
Enter password: ****
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
