Linux中Mysql 开启二进制日志功能

[root@localhost ~]# vi /etc/my.cnf

log_bin = mysql-bin      //等号两边不能有空格
server_id = 67

 重启mysql 服务

service mysqld restart

 

[root@localhost ~]# mysql -u root -p
Enter password:

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