navicat 连接 mysql 连接出现Authentication plugin 'caching_sha2_password' cannot be loaded

1.进行mysql bin中打开cmd登录

mysql -uroot -proot1

2.修改加密规则 

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root1' PASSWORD EXPIRE NEVER;   

3.更新一下用户的密码 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root1';   

4. 刷新权限

FLUSH PRIVILEGES;