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

解决办法：

1
mysql>SET global read_only=0;
（关掉新主库的只读属性）
1
2
3
mysql>FLUSH privileges;
mysql>SET global read_only=1; (读写属性)
mysql>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.
1
2
mysql>SETSESSION binlog_format ='ROW';
mysql>SET GLOBAL binlog_format ='ROW';