Mysql error : cannot execute statement : impossible to write to binary log since BINLOG_FORMAT=STATEMENT

After setup the mysql database many times users got error during execution of script on database "cannot execute statement : impossible to write to binary log since BINLOG_FORMAT=STATEMENT"

Two ways to solve this error.

Solution 1 : BINLOG_FORMAT was set to STATEMENT. Changing to fixed the problem through mysql shell as given below script.

mysql> SET GLOBAL binlog_format = 'MIXED';

Solution 2: Edit my.ini file (via notepad) : C:\%\Config\Mysql\my.ini
Modify the Binary Log Format from –
# binary logging format
binlog-format=STATEMENT

To –
binlog-format=MIXED
Save file. Restart MySQL.

Mysql error : cannot execute statement : impossible to write to binary log since BINLOG_FORMAT=STATEMENT

Tags