mac mysql 启动日志_Mac brew install MySQL 开启binlog日志

sudo vi /usr/local/etc/my.cnf    //添加内容如下：

[mysqld]

#log_bin

log-bin = mysql-bin #开启binlog

binlog-format = ROW #选择row模式

server_id = 1 #配置mysql replication需要定义，不能和canal的slaveId重复

mysql.server restart   // 重启mysql

localhost:~ shaozeming$ mysql.server restart

Shutting down MySQL

.... SUCCESS!

Starting MySQL

. SUCCESS!

show variables like '%log_bin%';查看是否开启

mysql> show variables like '%log_bin%';

+---------------------------------+--------------------------------------+

| Variable_name | Value|

+---------------------------------+--------------------------------------+

| log_bin | ON |

| log_bin_basename| /usr/local/var/mysql/mysql-bin |

| log_bin_index | /usr/local/var/mysql/mysql-bin.index |

| log_bin_trust_fu