This function has a none of deterministic, NO SQL, or READS SQL DATA in its declaration and binary

This function has a none of deterministic, NO SQL, or READS SQL DATA in its declaration and binary

MySQL settings by default are not allowed to create functions

Workaround 1:

Perform:

SET GLOBAL log_bin_trust_function_creators = 1;

But it doesn't work when it's restarted.

Note: The slave must be set at the time of the master copy, or it will cause master-slave synchronization to fail.

Workaround 2:

Set inside the MY.CNF

Log-bin-trust-function-creators=1

But this needs to restart the service.

This article is from the "Give Me Three moles" blog, please be sure to keep this source http://wushuangjay.blog.51cto.com/3125450/1561873

This function has a none of deterministic, NO SQL, or READS SQL DATA in its declaration and binary