标题: MySQL：The MySQL server is running with the --skip-grant-tables option [打印本页] 作者: 耶耶耶耶耶 时间: 2024-9-9 10:47 标题: 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
办理办法：
#关掉新主库的只读属性
mysql> set global read_only=0;
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.