mysql ERROR 1418 (HY000)

 ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQLDATA in its declaration binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
 解决方法： 1.mysql> SET GLOBAL log_bin_trust_function_creators = 1;
  2.在登录MySQL服务器是，加上 “--log-bin-trust-function-creators=1 ”参数并设置为1。
  3.一劳永逸的方法，在my.ini（my.cnf）中的[mysqld]区段中加上 log-bin-trust-function-creators=1。