MySQL Create function report "error 1418" errors, cannot create function

MySQL Create function report error 1418 wrong, cannot create function, according to official hint is said, can not create a function may be a security setting configuration or function is not open cause, let us look together.

Error

ERROR 1418 (HY000): This function has none of the deterministic, NO SQL, or READS SQL DATA in its declaration and binary Loggi NG is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
ERROR 1418 (HY000): This function has none of the deterministic, NO SQL, or READS SQL DATA in its declaration and binary Loggi NG is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Analysis:

The MySQL function cannot be created and is not enabled.

According to the system prompts, the cause of this error may be a security configuration, the manual log_bin_trust_function_creators parameter default 0, is not allowed to synchronize the function, generally when we configure repliaction, Forget to focus on this parameter so that after master updates funtion, slave will report an error and then slave stoped.
Processing process:

Workaround: The MySQL function cannot be created and is not enabled:

Mysql> Show variables like '%func% '; + ——————————— + ——-+| variable_name | Value |+ ——————————— + ——-+| log_bin_trust_function_creators | OFF |+ ——————————— + ——-+1 row in Set (0.00 sec) mysql> set global Log_bin_trust_function_creators=1; Query OK, 0 rows Affected (0.00 sec) mysql> Show variables like '%func% '; + ——————————— + ——-+| Variable_name                            | Value   |+ ——————————— + ——-+| log_bin_trust_function_creators  | On |+ ——————————— + ——-+1 row in Set (0.00 sec) mysql>

If the above method does not successfully resolve the error 1418 in MySQL, then you have to use the following method to try:

First step: mysql> SET GLOBAL log_bin_trust_function_creators = 1;

Step two: –log-bin-trust-function-creators=1 at system startup

Step three: Add a line of Log-bin-trust-function-creators=1 to the [mysqld] tag in My.ini (Linux my.conf) file

MySQL Create function report "error 1418" errors, cannot create function