安装mysql8.*之后，出现连接不上的问题

错误为： Failed to Connect to MySQL at 10.211.55.6:3306 with user root 

Authentication plugin 'caching_sha2_password' cannot be loaded

大概是新的mysql加密方式所用的查件，navicat不支持。

解决方案在

https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded?noredirect=1&lq=1

方法是

cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"--你mysql所在的目录

C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u root -p
Enter password: *********

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

mysql> exit