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)
网友评论