账号登录报错ERROR 1524 (HY000): Plugin ‘*‘ is not loaded

某账号登录报错

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;