# 拉取镜像 ``` docker pull mysql:5.7 ``` # 编辑 my.cnf ``` [client] default_character_set=utf8 [mysql] default-character-set=utf8 [mysqld] init_connect='SET collation_connection = utf8_unicode_ci init_connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_unicode_ci key_buffer_size = 128M max_allowed_packet = 1024M table_open_cache = 512 sort_buffer_size = 128M net_buffer_length = 8K read_buffer_size = 512M read_rnd_buffer_size = 128K myisam_sort_buffer_size = 32M thread_cache_size = 128 query_cache_size = 512M tmp_table_size = 128M max_connections = 1000 innodb_buffer_pool_size = 2048M innodb_log_file_size = 256M innodb_log_buffer_size = 32M log-bin=/var/log/mysql/mysql-bin binlog_format=mixed server-id = 1 expire_logs_days = 10 lower_case_table_names=1 ``` # 启动命令 ``` docker run --restart=always --name mysql5.7 -p 3306:3306 -v /opt/mysql/data:/var/lib/mysql -v /opt/mysql/conf:/etc/mysql/conf.d -v /opt/mysql/logs:/var/log/mysql -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7 ```