mysql报错信
The MySQL server is running with the --skip-grant-tables option
so it cannot execute
解决办法:
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';