#搜索镜像
docker search mysql:5.7
#拉取镜像
docker pull mysql:5.7
#创建目录
mkdir -p /home/mysql/conf /home/mysql/logs /home/mysql/data
#写入配置文件（见下方）
vim /home/mysql/conf/my.cnf
chmod 644 /home/mysql/conf/my.cnf
chmod 777 /home/mysql/*
[mysqld]
port=3306
collation-server=utf8_general_ci
init-connect='SET NAMES utf8'
character-set-server=utf8
max_allowed_packet=1000M
lower_case_table_names=1
innodb_file_per_table=1
default-storage-engine=INNODB
sql_mode='NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER'
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#general_log=on
#general_log_file=/var/lib/mysql/logs/mysql.log
#slow_query_log=on
#log-queries-not-using-indexes=on
#slow-query-log-file=/var/lib/mysql/logs/slowquery.log
#long_query_time=3
#log-bin=mysql-bin
#binlog_format=mixed
#server-id=1
#plugin-load-add=validate_password.so
#validate-password=FORCE_PLUS_PERMANENT
#validate_password_length=8
#validate_password_mixed_case_count=1
#validate_password_number_count=1
#validate_password_policy=1
#plugin-load-add=connection_control.so
#connection-control=FORCE_PLUS_PERMANENT
#connection-control-failed-login-attempts=FORCE_PLUS_PERMANENT
#connection_control_failed_connections_threshold=5
#connection_control_min_connection_delay=108000
wait_timeout=1800
interactive_timeout=1800
# default_password_lifetime=90
[client]
port=3306
default-character-set=utf8
[mysql]
port=3306
default-character-set=utf8#运行容器
docker run -d -p 3306:3306 \
--name mysql \
--net=host \
-v /home/mysql/conf/my.cnf:/etc/my.cnf \
-v /home/mysql/logs:/var/log \
-v /home/mysql/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=你的密码 mysql:5.7 --lower_case_table_names=1 --max-allowed-packet=1073741824 --character_set_server=utf8 --innodb_log_file_size=256m
【注：如果出现报错卸载掉libseccomp，重新安装新版本】
rpm -qa | grep libseccomp
rpm -e libseccomp-devel-2.3.1-4.el7.x86_64 --nodeps
wget http://rpmfind.net/linux/centos/8-stream/BaseOS/x86_64/os/Packages/libseccomp-2.5.1-1.el8.x86_64.rpm
rpm -ivh libseccomp-2.5.1-1.el8.x86_64.rpm
#查看运行的容器
docker ps
#修改配置文件，重启
vim /home/mysql/conf/my.cnf
docker restart mysql
#进入mysql容器
docker exec -it mysql bash
#查看日志
docker inspect --format '{{.LogPath}}' d37a20271c37（容器ID）