Mysql-docker 搭建以及宿主机配置数据持久化

1.安装docker

2.docker配置国内镜像

在/etc/docker/下增加 daemon.json

{
"regstry-mirrors": ["https://registry.docker-cn.com"]
}
之后 systemctl daemon-reload

systemctl restart docker

3.docker pull mysql5.7

4.运行docker-mysql5.7容器：

docker run -d -p 13307:3306  -e MYSQL_ROOT_PASSWORD=test123456 --name mysql-docker  mysql:5.7

进入mysql容器，查看/etc/my.cnf

拷贝my.cnf到宿主机、home/mysql/mysql_conf/下

并做修改如下：

[mysqld]
character-set-server=utf8
wait_timeout=31536000
interactive_timeout=31536000
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

skip-host-cache
skip-name-resolve
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.sock
secure-file-priv=/var/lib/mysql-files
user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

#log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/var/run/mysqld/mysqld.sock

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

5.停止并删除容器

查看容器docker ps

docker stop 容器id

docker rm 容器id

6.重新建立容器

docker run -d -p 13307:3306  -v /home/mysql/mysql_conf/my.cnf:/etc/my.cnf  -v  /home/mysql/data:/var/lib/mysql  -e MYSQL_ROOT_PASSWORD=test123456 --name mysql-docker mysql:5.7

这样而来，数据都在宿主机data中，拷贝留着，以后迁服务器的时候数据转移用