1.创建外部目录
mkdir /docker/mysql/config
mkdir /docker/mysql/data
cd /docker/mysql/config
vi my.cnf
2.创建my.cnf,写入以下配置
[mysqld]
user=mysql
character-set-server=utf8
default_authentication_plugin=mysql_native_password
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
3.启动mysql
docker run -d -p 3306:3306 --name mysql3306 -e MYSQL_ROOT_PASSWORD=123456-v /docker/mysql/config/my.cnf:/etc/mysql/my.cnf -v /docker/mysql/data/mysql:/var/lib/mysql mysql:5.7



