安装MySQL8.0.38

相关博客：https://blog.csdn.net/u014282578/article/details/127920419

1. 拉取镜像

docker pull mysql:8.0.38

2. 记住对应的镜像id，然后给镜像改个名

docker tag 镜像id mysql8.0.38

3. 运行命令，注意在本地创建文件夹

docker run --name mysql8.0.38 -v D:/myDockerFiles/mysql8.0.38/log:/var/log/mysql -v D:/myDockerFiles/mysql8.0.38/data:/var/lib/mysql -v D:/myDockerFiles/mysql8.0.38/conf:/etc/mysql/conf.d -p 13306:3306 -e MYSQL_ROOT_PASSWORD=root -d mysql:8.0.38 --init-connect="SET collation_connection=utf8mb4_0900_ai_ci" --init-connect="SET NAMES utf8mb4" --skip-character-set-client-handshake

4. 进入容器，修改配置

逐行运行

# 进入容器
docker exec -it 容器id /bin/bash

# 进入mysql
mysql -uroot -proot

# 修改配置
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'root';

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';

# 刷新权限
flush privileges;