1:拉取mysql镜像
docker pull mysql:5.7
2:在root目录下创建挂载目录目录用于存放配置信息和数据
mkdir /root/mysql
3:创建my.cnf配置文件
touch /root/mysql/conf/my.cnf
4:修改配置文件
vi /root/mysql/conf/my.cnf
添加
[mysqld]
user=mysql
character-set-server=utf8
default_authentication_plugin=mysql_native_password
secure_file_priv=/var/lib/mysql
expire_logs_days=7
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
max_connections=1000
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
5:运行容器
docker run --name mysql_5.7 -p 3306:3306 -v $PWD/conf/my.cnf:/etc/mysql/my.cnf -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
