解决连接Mysql数据库出现“Client does not support authentication protocol requested by server”

问题：visual studio连接Mysql数据库的时候出现“Client does not support authentication protocol requested by server”
解决办法：改变连接 MySQL 帐户的加密方式mysql8 之前是通过 mysql_native_password这种方式加密的。mysql8之后,加密规则是caching_sha2_password。

MySQL->SETPASSWORDFOR'root'@'localhost'=OLD_PASSWORD('new_password');
MySQL->FLUSH PRIVILEGES;
MySQL->UPDATE MySQL.user SET Password=OLD_PASSWORD('new_password') WHERE Host='localhost' AND User='root';
MySQL->FLUSH PRIVILEGES;

如果用Navicat Premium可以直接选择

• 用户》》插件》》选择mysql_native_password