theskett + deterministic   3

mysql - DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled - Stack Overflow
There are two ways to fix this:

Execute the following in the MySQL console:

SET GLOBAL log_bin_trust_function_creators = 1;

Add the following to the mysql.ini configuration file:

log_bin_trust_function_creators = 1

The setting relaxes the checking for non-deterministic functions. Non-deterministic functions are functions that modify data (i.e. have update, insert or delete statement(s)). For more info, see here.

Please note, if binary logging is NOT enabled, this setting does not apply.
mysql  binlog  functions  deterministic  database  import  fail  failed 
november 2015 by theskett

Copy this bookmark:



description:


tags: