Cause: java.sql.SQLException: Cannot execute statement: impossible to write to binary log

 mysql  SET GLOBAL binlog_format=MIXED;
Query OK, 0 rows affected (0.00 sec)

但是这样只会一次性

为了永久生效,需要修改my.ini

# 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

最新回复(0)
/jishuBfXENCzF_2FVP4SQ_2B7pRbhr1FycRT3THYzIYFpsX9J_2FYg_3D4691920
8 简首页