如何在服务器上用docker部署mysql8

255 阅读1分钟

1-首先使用docker下载mysql8的镜像

docker pull mysql:8.0.18

2-启动mysql8的容器

docker run --name mysql8 -e MYSQL_ROOT_PASSWORD=123456 -v /usr/local/mysql/logs:/logs -v /usr/local/mysql/data:/var/lib/mysql -p 3306:3306 -d mysql:8.0.18

3- 进入mysql8 的容器内

docker exec -it mysql8 /bin/bash

4-设置mysql的配置 使得连接不报错

mysql -uroot -p123456 use mysql; ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; FLUSH PRIVILEGES;

5-退出mysql8的容器,然后重启

docker restart mysql8