数据库:percona5.7.11
今天登陆数据库的时候报错
[root@leo ~]# mysql -uroot -p
Enter password:
ERROR 1524 (HY000): Plugin ' *9E53930467B20A15727780FB02007B379CE21A84 ' is not loaded
报错大概的意思 *9E53930467B20A15727780FB02007B379CE21A84没有加载
错误原因:
mysql登录验证密码插件是 mysql_native_password (mysql.user表中的plugin字段记录的是密码插件 ),而现在这个用户的登录密码插件是 XXXXXXXXXXXXX,所有会报错
解决方法:
使用 skip-grant-tables方法进入数据库
select user,password,plugin from user where user='root ' ;
mysql> select user,password,plugin from user;
+-------+----------+-------------------------------------------+
| user | password | plugin |
+-------+----------+-------------------------------------------+
| root | | *9E53930467B20A15727780FB02007B379CE21A84 |
+-------+----------+-------------------------------------------+
1 rows in set (0.00 sec)
果然 plugin被修改过
mysql> update user set plugin=' mysql_native_password ' where user='root ' ; 修改回来
mysql> flush privileges;
解决
今天登陆数据库的时候报错
[root@leo ~]# mysql -uroot -p
Enter password:
ERROR 1524 (HY000): Plugin ' *9E53930467B20A15727780FB02007B379CE21A84 ' is not loaded
报错大概的意思 *9E53930467B20A15727780FB02007B379CE21A84没有加载
错误原因:
mysql登录验证密码插件是 mysql_native_password (mysql.user表中的plugin字段记录的是密码插件 ),而现在这个用户的登录密码插件是 XXXXXXXXXXXXX,所有会报错
解决方法:
使用 skip-grant-tables方法进入数据库
select user,password,plugin from user where user='root ' ;
mysql> select user,password,plugin from user;
+-------+----------+-------------------------------------------+
| user | password | plugin |
+-------+----------+-------------------------------------------+
| root | | *9E53930467B20A15727780FB02007B379CE21A84 |
+-------+----------+-------------------------------------------+
1 rows in set (0.00 sec)
果然 plugin被修改过
mysql> update user set plugin=' mysql_native_password ' where user='root ' ; 修改回来
mysql> flush privileges;
解决
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29989552/viewspace-2087981/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29989552/viewspace-2087981/