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.ini文件中配置了skip-grant-tables，前面加个#注释掉就可以了修改mysql的配置文件，把第二种：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';set global read_only=0; 关闭只读,可以读写 set global read_only=0; 关闭只读,可以读写 set global read_only=1; 开始只读模式