问题:在虚拟机的docker容器中启动mysql服务之后,在宿主机中使用navicat连接虚拟机中的mysql出现下图报错:
2059 : Authentication plugin ‘caching_sha2_password’ cannot be loaded:
解决:
1,[root@tian ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
a18ec2100369 mysql "docker-entrypoint.s…" 6 minutes ago Up 6 minutes 0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp mysql01
服务正常启动没问题
2,进入mysql容器:
[root@tian ~]# docker exec -it a18ec2100369 /bin/bash
3,进入mysql服务:
root@a18ec2100369:/# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.