(1)pull镜像
docker pull mysql:5.6
(2)启动
docker run -p 3306:3306 --name mymysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6
(3)复制容器需要挂载的目录
docker cp mymysql:/var/lib/mysql /opt/mysql/data/
docker cp mymysql:/etc/mysql/conf.d/ /opt/mysql/conf
(4)停止mysql容器
docker stop mymysql
(5)删除2中创建的容器
docker rm mymysql
(6)新建docker-compose.yml
version: "3"
services:
db:
container_name: db
image: mysql:5.6
ports:
- "3306:3306"
environment:
- MYSQL_ROOT_PASSWORD=123456
volumes:
- ./data/mysql:/var/lib/mysql
- ./conf/conf.d:/etc/mysql/conf.d
(7)启动
docker-compose up -d
(8)修改docker.cnf的sql_mode
(9)用客户端连接验证
select @@GLOBAL.sql_mode