ERROR 1665 (HY000)

MySQL错误ERROR 1665解决方案

ERROR 1665 (HY000): 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.


解决方案:

将binlog_format中的STATEMENT换成MIXED

set global binlog_format=mixed;

设置完后要退出mysql后重新登入才可生效