mysql 错误 You need to use –log-bin to make –binlog-format work

出现此错误的原因是 你注释掉了

/etc/my.cnf 文件中的

log-bin=mysql-bin ，但是没有注释掉binlog_format 这条

 

解决办法：编辑my.cnf文件，将binlog_format 这条注释掉.

摘要片段：

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin


# binary logging format - mixed recommended
binlog_format=mixed