2059 - Authentication plugin ‘xxxxxxx’ cannot be loaded:XXXX(无法加载身份验证插件)
2059 - Authentication plugin ‘xxxxxxx’ cannot be loaded:XXXXXX (无法加载身份验证插件)
原因:mysql8 之前的版本中加密规则是mysql_native_password,而在mysql8之后,加密规则是caching_sha2_password
解决办法:更改加密规则
选择mysql数据库
mysql> use mysql;
1、更改加密方式
mysql> ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.08 sec)
2、更新用户密码
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.02 sec)
3、刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
之后再次连接就能成功了。