Docker安装MySQL外部挂载配置文件

1、MySQL版本5.7.22

2、在宿主机上创建配置文件

/etc/mysql/mysql.conf.d/mysqld.cnf

内容如下：

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
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
lower_case_table_names=1

init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci


max_connections = 1000

lower_case_table_names=1，表名忽略大小写。

3、创建docker容器

 docker run --name mysql5.7 -p 3306:3306 --restart=always -e MYSQL_ROOT_PASSWORD=root -v /etc/mysql/mysql.conf.d/mysqld.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf  -v /var/lib/mysql:/var/lib/mysql  -d mysql:5.7.22

4、查看字符集

show variables like'character%';