IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    mysql General error: 1665 Cannot execute statement BINLOG_FORMAT错误解决

    usity发表于 2016-10-10 09:11:52
    love 0

    General error: 1665 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> mysql -u root -p mysql;
     mysql> SET GLOBAL binlog_format=MIXED;
     mysql> exit;

     

    但是这样只会一次性
    为了永久生效,需要修改my.ini (linux etc/my.cnf)
    # Remove leading
    # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    log_bin = E:/mysql56/log_bin/log_bin.log
    #relay_log = E:/mysql56/log_bin/relay_log.log
    #read_only = 1
    # binary logging format - mixed recommended
    binlog_format=mixed



沪ICP备19023445号-2号
友情链接