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;