https://hub.docker.com/_/mysql/

#docker run

docker run -d  -p 3316:3306   --privileged=true  --name mysql --restart=always  -v /etc/localtime:/etc/localtime:ro -v /data/db/mysql8:/var/lib/mysql -v /data/docker/mysql/mysql8/conf.d:/etc/mysql/conf.d:ro  -v  /data/docker/mysql/mysql8/my.cnf:/etc/mysql/my.cnf:ro  -e MYSQL_ROOT_PASSWORD=wdqdmm@r  -e MYSQL_ALLOW_EMPTY_PASSWORD=no  -v  /data/file:/var/lib/mysql-files  mysql:latest   --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci  --default-authentication-plugin=mysql_native_password

#docker labs

docker run -d  -p 3326:3306  --name mysqllabs  --restart=always  -v /etc/localtime:/etc/localtime:ro  -e MYSQL_ROOT_PASSWORD=wdqdmm@r  -e MYSQL_ALLOW_EMPTY_PASSWORD=no  -v  /data/file:/data/file/  mysql:latest   --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci  --default-authentication-plugin=mysql_native_password

#日志

vim   /data/docker/mysql/mysql8/my-1.cnf

[mysqld]
skip-host-cache
skip-name-resolve
secure_file_priv=/var/lib/mysql-files
#关闭log-bin功能
#skip-log-bin
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
server-id                            =  1
bind-address                     = 0.0.0.0
default_storage_engine  = InnoDB
#启用二进制日志, row复制模式,具有最高性能.
log-bin=mysql-bin
binlog_format=row
#实时写，实时刷
innodb_flush_log_at_trx_commit=1
general_log = 1
general_log_file              = /var/log/mysql/query.log
slow_query_log = 1
long_query_time = 2
slow_query_log_file  = /var/log/mysql/slow.log
log-error  = /var/log/mysql/error.log
log_bin = /var/log/mysql/mysql-bin
log_bin_index = /var/log/mysql/mysql-bin.index
binlog_expire_logs_seconds = 7
max_binlog_size = 200M
#skip-grant-tables
max_connections = 10000
max_allowed_packet = 500M
wait_timeout= 600
interactive_timeout = 600
character-set-client-handshake=FALSE
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
# Custom config should go here
!includedir /etc/mysql/conf.d/

vim  /data/docker/mysql/mysql8/conf.d/docker.cnf

[mysqld]
skip-host-cache
skip-name-resolve

vim  /data/docker/mysql/mysql8/conf.d/mysql.cnf

[mysql]

#无日志

vim   /data/docker/mysql/mysql8/my-0.cnf

[mysqld]
skip-host-cache
skip-name-resolve
secure_file_priv=/var/lib/mysql-files
#关闭log-bin功能
skip-log-bin
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
symbolic-links=0
bind-address                     = 0.0.0.0
default_storage_engine  = InnoDB
general_log = 1
general_log_file              = /var/log/mysql/query.log
slow_query_log = 1
long_query_time = 2
slow_query_log_file  = /var/log/mysql/slow.log
log-error  = /var/log/mysql/error.log
#skip-grant-tables
max_connections = 10000
max_allowed_packet = 500M
wait_timeout= 600
interactive_timeout = 600
character-set-client-handshake=FALSE
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
# Custom config should go here
!includedir /etc/mysql/conf.d/

#默认

vim   /data/docker/mysql/mysql8/my.cnf

[mysqld]
skip-host-cache
skip-name-resolve
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv=
bind-address = 0.0.0.0
default_storage_engine = InnoDB
#skip-grant-tables
max_connections = 10000
max_allowed_packet = 500M
wait_timeout= 600
interactive_timeout = 600
# Custom config should go here
!includedir /etc/mysql/conf.d/