在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
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; 关闭只读,可以读写 mysql> set global read_only=0; Query OK, 0 rows affected (0.00 sec) mysql> show variables like '%read_only%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | innodb_read_only | OFF | | read_only | OFF | | tx_read_only | OFF | +------------------+-------+ 3 rows in set (0.00 sec) mysql> set global read_only=1; Query OK, 0 rows affected (0.00 sec) mysql> show variables like '%read_only%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | innodb_read_only | OFF | | read_only | ON | | tx_read_only | OFF | +------------------+-------+ 3 rows in set (0.00 sec) set global read_only=0; 关闭只读,可以读写 set global read_only=1; 开始只读模式 |
请发表评论