MySQL 连接出现 Authentication plugin 'caching_sha2_password' cannot be loaded

2022-05-07 02:06:36

MySQL 连接出现 Authentication plugin ‘caching_sha2_password’ cannot be loaded

解决方案

# 使密码从不过期， 123456 是数据库密码
ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
# 定义可通过密码远程连接
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
# 刷新权限
FLUSH PRIVILEGES;