Linux下MySQL打开binlog日志

查看binlog日志是否打开

mysql> SHOW VARIABLES LIKE 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | OFF    |
+---------------+-------+

Linux 环境编辑/etc/my.cnf文件，在[mysqld]下加
server-id=1
log-bin=mysql-bin

保存退出后重启mysql服务