修改 docker 中 MySQL 配置文件,在 mysqld 项目下新增 port=3307 配置
[mysqld]
port=3307
federated
max_connections = 200
max_allowed_packet = 64M
pid-file= /var/run/mysqld/mysqld.pid
socket= /var/run/mysqld/mysqld.sock
datadir= /var/lib/mysql
#log-error= /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address= 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#限制mysql内存占用
#performance_schema_max_table_instances=400
#table_definition_cache=400
#table_open_cache=256
character-set-server=utf8
collation-server=utf8_general_ci
skip-character-set-client-handshake
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8
[mysqld_safe]
default-character-set=utf8
之后执行 mysql.sh 脚本
#!/usr/bin/env bashconfig_dir=`pwd`
PASSWORD=123456
docker run -d --net host --name solo_mysql -p 3307:3307 -e MYSQL_ROOT_PASSWORD=$PASSWORD -e TZ=Asia/Shanghai --restart=always -v ${config_dir}/mysqld.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf mysql:5.7
exit
若容器已经生成，则先停止宿主机 MySQL 服务，之后启动容器，通过 docker exec 命令进入容器中，修改 /etc/mysql/mysql.conf.d/mysqld.cnf 配置文件即可