Navicat连接报错：Authentication plugin 'caching_sha2_password' cannot be loaded的处理方法

问题

产生原因

MySQL8.0版本加密规则不同导致

解决

-- 1.修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
-- 2.更新用户密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
-- 3.刷新权限
FLUSH PRIVILEGES;
-- 4.重置新密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';