1、先从Docker HUB中摘取最新版本的mysql镜像: docker image pull mysql:latest
2、创建临时mysql容器: docker container run -d --name mysql_temp mysql:latest
3、将mysql_temp容器中mysql的配置路径拷贝到所在主机: docker container cp mysql_temp:/etc/mysql/conf.d conf
4、删除临时mysql容器:docker container rm -f mysql_temp
5、挂载外部配置和数据安装
mkdir /root/docker
mkdir /root/docker/mysql
mkdir /root/docker/mysql/conf.d
mkdir /root/docker/mysql/data/
6、创建my.cnf配置文件
touch /root/docker/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=