This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA 解决方法

今天将数据库备份还原到另外一个服务器的数据库上时报如下错误：

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)

 

这种错误的解决方法：
set global log_bin_trust_function_creators=TRUE;