Mysql Create function appears this function has none of deterministic, NO SQL, or READS SQL DATA

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.

Mysql Create function appears this function has none of deterministic, NO SQL, or READS SQL DATA