MySQL报错：The MySQL server is running with the --skip-grant-tables option so it cannot execute this st

The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

解决办法：

mysql> set global read_only=0;
（关掉新主库的只读属性）

 flush privileges;

set global read_only=1;(读写属相)

 flush privileges;

Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

  mysql> SET SESSION binlog_format = 'ROW';
   mysql> SET GLOBAL binlog_format = 'ROW';

摘自：http://www.cnblogs.com/xionghui/archive/2013/03/01/2939342.html