MySQL问题:2059 - Authentication plugin 'caching_sha2_password' cannot be loaded....

问题描述:

Server version: 8.0.21-0ubuntu0.20.04.4 (Ubuntu)

 

 

解决方案:

MySQL 8.0 之前的版本中加密规则是mysql_native_password,MySQL 8.0 之后,加密规则是caching_sha2_password

 

修改加密规则即可

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Admin@9000' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Admin@9000';
Query OK, 0 rows affected (0.02 sec)

mysql> ALTER USER 'root'@'%' IDENTIFIED BY 'Admin@9000' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Admin@9000';
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql>

 

posted @ 2020-09-25 13:56  xzming8  阅读(642)  评论(0)    收藏  举报