Navicat 连接MySQL Authentication plugin ‘caching_sha2_password‘ cannot be loaded

最近我使用docker 安装 mysql 

顺便就贴一下：

# 拉取镜像
docker pull mysql:latest
# 查看镜像
docker images
# 运行
docker run -itd --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql
# 查看是否运行
docker ps
# 进入mysql容器(mysqlName为 docker ps中显示的name！)
docker exec -it mysqlName bash
# 登录
mysql -u root -p 
# 输入密码
123456
 

 

使用navicat登录报错

Authentication plugin 'caching_sha2_password' cannot be loaded

 

# 登录
mysql -uroot -p 
# 输入密码
123456
 
# 选择库
use mysql;
 
#运行命令
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; 
 
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; 
 
# 刷新
FLUSH PRIVILEGES; 

 

就可以连上了