MySQL:开启bin log

[mysqld]
log-bin=mysql-bin
server_id=1

mysql5.7以后要求必须填写server-id

mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |
+---------------+-------+
1 row in set (0.01 sec)