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。
解决方法: 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。