拉mysql5.7

docker pull mysql:5.7

创建一份my.cnf,修改一些配置

my.cnf文件内容
[mysqld]
user=mysql
character-set-server=utf8mb4
default_authentication_plugin=mysql_native_password
## secure_file_priv=/var/lib/mysql 
expire_logs_days=7
max_connections=1000
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

mysql启动命令

docker run -d -p 3309:3306 --privileged=true --restart=always  -v /usr/local/docker/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /usr/local/docker/mysql/data:/var/lib/mysql -v /usr/local/docker/mysql/log:/var/log/mysql -v /usr/local/docker/mysql/mysql-files:/var/lib/mysql-files/ -v /usr/local/docker/mysql/conf:/etc/mysql -e MYSQL_ROOT_PASSWORD=123456 --name mysql5.7 mysql:5.7 mysql:5.7

查看是否启用成功

docker ps

进入容器内部

docker exec -it redis /bin/bash

查看日志

docker logs --tail 500 --follow --timestamps mysql5.7