docker安装mysql-8

1. 卸载docker:
yum remove -y docker-ce \
                  docker-ce-cli \
                  docker-ce-rootless-extras \
                  containerd.io \
                  docker-buildx-plugin \
                  docker-compose-plugin

2.配置下载源：sudo yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo

3.下载最新版本：sudo yum install -y docker-ce docker-ce-cli containerd.io docker-compose-plugin
3.1 列举可下载版本：yum list docker-ce --showduplicates | sort -r
3.2：下载指定版本：sudo yum install -y docker-ce-<VERSION> docker-ce-cli-<VERSION> containerd.io
4.启动：sudo systemctl start docker
5.设置开机自启：sudo systemctl enable docker
6.获取阿里云镜像加速地址：链接前往，需登录：https://cr.console.aliyun.com/cn-hangzhou/instances/artifact

docker pull mysql:8.0.21


{
"registry-mirrors": [
"https://tyxs05w2.mirror.aliyuncs.com"
]
}


http://223.71.143.65:10045/reportGenerateAssistant/reportGenerateAssistant.html#/reportGenerateAssistant/index

http://223.71.143.65:10045/government/admin/index.html

https://blog.youkuaiyun.com/qq_42402854/article/details/108746572

docker run -d --name mysql8 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql:8.0.21


docker run -d --name mysql8.0 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=123456 -e MYSQL_DEFAULT_AUTHENTICATION_PLUGIN=mysql_native_password mysql:8.0.21

docker run -d --name mysql8.0 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql:8.0.21 --default-authentication-plugin=mysql_native_password

mysql配置文件挂载命令：
cat > /root/mysql/conf/my.cnf << EOF
[mysqld]
default_authentication_plugin=mysql_native_password
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

[client]
default-character-set=utf8mb4
EOF

docker run -d --name mysql8 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=123456  -v /root/mysql/conf:/etc/mysql/conf.d  mysql:8.0.21

进入mysql容器：docker exec -it mysql8.0 mysql -uroot -p123456


docker exec -it mysql8 mysql -uroot -p123456 -e "SELECT user, host, plugin FROM mysql.user;"

你可以通过以下SQL命令查询当前的默认认证插件：SELECT @@default_authentication_plugin;