查看“︁MySQL:开启bin log”︁的源代码

<source lang="bash">
[mysqld]
log-bin=mysql-bin
server_id=1
</source>
mysql5.7以后要求必须填写server-id
<pre>
mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |
+---------------+-------+
1 row in set (0.01 sec)
</pre>

[[Category:Database]]