在docker中安装mysql 8.0后面版本解决Authentication plugin 'caching_sha2_password' cannot be loaded

启动docker服务
sudo systemctl start docker
查看docker的版本
sudo docker version
配置阿里云的镜像地址：
yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
yum更新下即可：
yum makecache fast

开机启动docker

sudo systemctl enable docker

docker拉取镜像命令 mysql

docker pull mysql:8.0.29

docker run -p 3306:3306 --name mysql \
-v /home/mysql/mysql-files:/var/lib/mysql-files \
-v /mydata/mysql/log:/var/log/mysql \
-v /mydata/mysql/data:/var/lib/mysql \
-v /mydata/mysql/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql:8.0.29

修改MySQL的配置文件 vim /mydata/mysql/conf/my.cnf

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
init_connect="SET collation_connection = utf8_unicode_ci"
init_connect="SET NAMES utf8"
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve

如果docker ps 没有看到对应的进程
先 docker logs -镜像names

1docker pa -a 
查看所有运行的容器
2 docker exec -it 895 /bin/bash
  进入正在运行的docker 中的mysql
3 mysql -u root -p (没有就直接回车)
#选择数据库
use mysql; 
 
# 注意：如果是远程连接，请将'localhost'换成'%'
//ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的数据库密码';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root'
 
#刷新权限
FLUSH PRIVILEGES;