MySQL：The MySQL server is running with the --skip-grant-tables option ...

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

1. #关掉新主库的只读属性
2. mysql> set global read_only=0;
3. flush privileges;
5. 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.
7. mysql> SET SESSION binlog_format = 'ROW';
8. mysql> SET GLOBAL binlog_format = 'ROW';

复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。