1 启动镜像(普通)

docker run --name mysql -p 3307:3306 -e MYSQL_ROOT_PASSWORD=123456 -d --restart=always mysql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

docker run  -d  \\
--name mysql8 \\
--privileged=true \\
--restart=always \\
-p 3306:3306 \\
-v /docker/mysql8/data:/var/lib/mysql \\
-v /docker/mysql8/config:/etc/mysql/conf.d  \\
-v /docker/mysql8/logs:/logs \\
-e MYSQL_ROOT_PASSWORD=123456 \\
-e TZ=Asia/Shanghai mysql:8.0.21 \\
--lower_case_table_names=1

2 启动binlog日志

2.1 创建my.cnf

创建/etc/mysql/my.cnf

[mysqld]
server-id=1
log_bin=mysql-bin
binlog_format=ROW
expire_logs_days=7
max_binlog_size=100M

2.2 启动服务

docker run -d --name mysql \\
-p 3306:3306 \\
-e MYSQL_ROOT_PASSWORD=123456 \\
-v /etc/mysql/my.cnf:/etc/mysql/my.cnf \\
-v /opt/mysql:/var/lib/mysql \\
-v /etc/localtime:/etc/localtime \\
mysql:5.7

2.3 校验是否启动

SHOW VARIABLES LIKE 'log_bin';

SHOW VARIABLES LIKE 'binlog_format';

SHOW VARIABLES LIKE 'server_id';

SHOW BINARY LOGS;