1 创建挂在目录
先创建mysql需要挂载的空文件夹
mkdir -p /docker/mysql/conf
mkdir -p /docker/mysql/log
mkdir -p /docker/mysql/data
2 创建自定义的mysql配置文件
在/docker/mysql/conf文件夹下,创建一个新的文件custom.cnf
以下是Dataease报表平台对于MySQL5.7数据库的配置,我直接把这些复制到custom.cnf
如果你不需要额外的配置,那就不用创建这个文件
[mysqld]
default-storage-engine=INNODB
character_set_server=utf8
lower_case_table_names=1
table_open_cache=128
max_connections=2000
max_connect_errors=6000
innodb_file_per_table=1
innodb_buffer_pool_size=1G
max_allowed_packet=64M
transaction_isolation=READ-COMMITTED
innodb_flush_method=O_DIRECT
innodb_lock_wait_timeout=1800
innodb_flush_log_at_trx_commit=0
sync_binlog=0
group_concat_max_len=1024000
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
skip-name-resolve
[mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8
3 run命令运行mysql容器
docker run -p 3306:3306 --name mysql \
-v /docker/mysql/conf:/etc/mysql/conf.d \
-v /docker/mysql/log:/var/log/ \
-v /docker/mysql/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=12345600 \
-d mysql:5.7