【MySQL】ERROR 1418 (HY000) This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA

MySQL 在创建函数时报如下错误：

[HY000][1418] 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)

解决方法：

set global log_bin_trust_function_creators=TRUE;