MySQL8.0提示 caching_sha2_passwor' cannot be loaded

一 SELECT `user`, `host`, `authentication_string`, `plugin` FROM mysql.user;查询如下,plugin为sha2

mysql> SELECT `user`, `host`, `authentication_string`, `plugin` FROM mysql.user;
+------------------+-----------+------------------------------------------------------------------------+-----------------------+
| user             | host      | authentication_string                                                  | plugin                |
+------------------+-----------+------------------------------------------------------------------------+-----------------------+
| dyh              | %         | $A$005$ Q>1R0Op75M2kJew/5OFKqmvS7D6q/h5cgG.2POywtwbzl18dk88JfB | caching_sha2_password |
| root             | %         | $A$005$Bze(?.uiHuo+'JcccNSbv.G7Juzvpap1q550VlNu5ElQ9Fw3YQabz3A2 | caching_sha2_password |
| mysql.infoschema | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| mysql.session    | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| mysql.sys        | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| root             | localhost | $A$005$ovbcM(;.sE,5Gxu#5xvBVrW8ILK7nXmr3rgqFX4.sc.Yy0jMgJexfYhCZo2 | caching_sha2_password |
+------------------+-----------+------------------------------------------------------------------------+-----------------------+

 

可以修改为老版本的mysql_native_password

GRANT ALL PRIVILEGES ON *.* TO 'dyh'@'%'  WITH GRANT OPTION;

flush privileges;