报错信息:

ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQ
    L 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 = 1;

以上mysql服务重启将失效,是临时的解决办法

终极解决方法:
在my.cnf文件中加入:

在初始化参数的 [mysqld] 节加上:log_bin_trust_function_creators=1