An ERROR 1418 is reported when you create a function in MySQL. You cannot create a function. According to the official prompt, the failure to create a function may be a security configuration or the function is not enabled. Let's take a look at it.
Error
ERROR 1418 (HY000): This function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its declaration and binary logging is enabled (you * might * want to use the less safe log_bin_trust_function_creators variable)
ERROR 1418 (HY000): This function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its declaration and binary logging is enabled (you * might * want to use the less safe log_bin_trust_function_creators variable)
Analysis:
MySQL functions cannot be created.
According to the system prompt, the cause of this error may be a security configuration. The log_bin_trust_function_creators parameter in the manual is 0 by default, and function synchronization is not allowed, generally, when configuring repliaction, we forget to pay attention to this parameter. In this way, after the master updates the funtion, slave reports an error and slave stoped.
Processing Process:
Solution:MySQL functions cannot be created, but functions are not enabled:
The Code is as follows: |
Copy code |
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 cannot solve the ERROR 1418 in mysql, try the following method:
Step 1: mysql> set global log_bin_trust_function_creators = 1;
Step 2: log-bin-trust-function-creators = 1 at system startup
Step 3: add a line of log-bin-trust-function-creators = 1 After marking [mysqld] In the my. ini (my. conf in Linux) File