win10下的mysql5.7开启binglog

log-bin = E:\\node-exclude\mysql5.7\mysql-5.7.42-binglog\mysql-bin
binlog_format = ROW
server_id = 2

[mysql]
# 设置mysql客户端默认字符集
default-character-set = utf8
[mysqld]
#设置3307端口
port = 3306
# 设置mysql的安装目录
basedir = E:\\node-exclude\mysql5.7\mysql-5.7.42-winx64
# 设置mysql数据库的数据的存放目录
datadir = E:\\node-exclude\mysql5.7\mysql-5.7.42-data
# 允许最大连接数
max_connections = 200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server = utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine = INNODB


log-bin = E:\\node-exclude\mysql5.7\mysql-5.7.42-binglog\mysql-bin
binlog_format = ROW
server_id = 2


bind-address = 0.0.0.0

slave-skip-errors = 1146

show_compatibility_56 = ON
performance_schema


skip-grant-tables