Mysql DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled

July 14, 2021 . 1 MIN READ

https://stackoverflow.com/questions/26015160/deterministic-no-sql-or-reads-sql-data-in-its-declaration-and-binary-logging-i

 

There are two ways to fix this:

  1. Execute the following in the MySQL console:

SET GLOBAL log_bin_trust_function_creators = 1;

  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.

Binary Logging of Stored Programs

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Anwar

Anwar

RECENT POSTS

TAGS

You Might Be Interested In

Tags

Navigation

Newsletter