InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMIT

1.起因

使用django连接mysql进行数据库操作的时候出现以下错误

InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMIT

 

2.解决方案

连续执行以下命令

SET GLOBAL binlog_format = 'STATEMENT';
SET GLOBAL binlog_format = 'ROW';
SET GLOBAL binlog_format = 'MIXED';

 

3.重新操作mysql数据库

 问题解决