Solution for "ERROR 1418" when creating a function in Mysql: 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) www.2cto.com SQL code mysql> show variables like '% func % '; + rows + ------- + | Variable_name | Value | + --------------------------------- + ------- + | log_bin_trust_function_creators | OFF | + rows + ------- + 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 % '; + functions + ------- + | Variable_name | Value | + --------------------------------- + ------- + | log_bin_trust_function_creators | ON | + ----------------------------- + -------