docker下的mysql my.ini_使用Docker安装mysql，挂载外部配置和数据

1、挂载外部配置和数据安装

mkdir /opt

mkdir /opt/mysql

mkdir /opt/mysql/conf.d

mkdir /opt/mysql/data/

创建my.cnf配置文件

touch /opt/mysql/my.cnf

my.cnf添加如下内容：

[mysqld]

user=mysql

character-set-server=utf8

default_authentication_plugin=mysql_native_password

secure_file_priv=/var/lib/mysql

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

2、创建容器，并后台启动

docker run --restart=always --privileged=true -d -v /opt/mysql/data/:/var/lib/mysql -v /opt/mysql/conf.d:/etc/mysql/conf.d -v /opt/mysql/my.cnf:/etc/mysql/my.cnf -p 33060:3306 --name my-mysql -e MYSQL_ROOT_PASSWORD&#