MySQLyou*might*wanttousethelesssafelog_bin_trust_function_creatorsvariable

报错信息&＃xff1a;

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 usethe less safe log_bin_trust_function_creators variable)


解决方法&＃xff1a;

SET GLOBAL log_bin_trust_function_creators &＃61; 1;


以上mysql服务重启将失效&＃xff0c;是临时的解决办法

终极解决方法&＃xff1a;
在my.cnf文件中加入&＃xff1a;

在初始化参数的 [mysqld] 节加上:log_bin_trust_function_creators&＃61;1