步骤一:在根目录下新建my.ini文件,具体内容如下
[mysqld]
log-bin=D:/mysql-5.7.28-winx64/data/binlog/mysql-bin
binlog-format=Row
server-id=125
步骤二:重启mysql
net stop mysql
net start mysql
步骤三:查看是否开启binlog
show variables like ‘%log_bin%’;
步骤一:在根目录下新建my.ini文件,具体内容如下
[mysqld]
log-bin=D:/mysql-5.7.28-winx64/data/binlog/mysql-bin
binlog-format=Row
server-id=125
步骤二:重启mysql
net stop mysql
net start mysql
步骤三:查看是否开启binlog
show variables like ‘%log_bin%’;