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

/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