mysql中创建函数遇到1418错误

错误信息:

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)

解决办法：

执行sql语句；
set global log_bin_trust_function_creators=TRUE;