某账号登录报错
ERROR 1524 (HY000): Plugin '*长字符串' is not loaded
在有权限的账号下查询
select user,plugin from mysql.user where user='';
| user | plugin |
| 该账号| *长字符串|
而查询root账号
select user,plugin from mysql.user where user='root';
查找所有不等于默认值的用户
select user,plugin from mysql.user where plugin !='mysql_native_password';
| user | plugin |
| root | mysql_native_password |
| root | mysql_native_password |
| root | mysql_native_password |
| root | mysql_native_password |
那么
update mysql.user set plugin ='mysql_native_password' where user='';
修改回来
需要刷新权限
flush privileges;