mysql8.0.11客户端无法登陆的解决方法

mysql>use mysql; mysql> select user, host, plugin, authentication_string from user where user='test';+------+------+-----------------------+------------------------------------------------------------------------+| user | host | plugin    | authentication_string             |+------+------+-----------------------+------------------------------------------------------------------------+| test | % | caching_sha2_password | $A$005$7/m5O/%K/Y3'I@j8.ifRKoGiqJD58kgBP8iZj0q9d8yaAr2zWYa4j4r3to0 |+------+------+-----------------------+------------------------------------------------------------------------+1 row in set (0.00 sec)

ALTER USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY '123456a?';