mysql开启binlog

1. 查看是否开启binlog
   运行sql show variables like ‘log_bin’;

2. 找到my.cnff文件(一般在 /etc下面)

#开启binlog(找个地方家这两句话)
log-bin=mysql-bin
server-id=1

3. 重启

service mysqld restart

4. 进入mysql查看设置

mysql>show variables like '%log_bin%';