Docker安装MySQL

Docker安装MySQL

1.Docker安装MySQL5.6

docker run -p 3307:3306 --name mysql56  --restart always  -v /data/docker/mysql56:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=docker@123 --privileged=true -d mysql:5.6  --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci   -e TZ=Asia/Shanghai 

2.Docker安装MySQL8.0

docker run --name mysql --restart=always \
    -v /data/docker/mysql80:/var/lib/mysql \
    -p 3308:3306 \
    -e MYSQL_ROOT_PASSWORD="Admin123" \
    -e TZ=Asia/Shanghai \
    -d mysql:8.0 --lower-case-table-names=1 --character-set-server=utf8mb4 --collation-server=utf8mb4_0900_ai_ci   -e TZ=Asia/Shanghai 

2.1 提示报错

2.2 执行命令

alter user 'root'@'%' identified with mysql_native_password by 'Admin123';