【MySQL数据库1418报错解决】

• 问题：

  使用mysql创建、调用存储过程，函数以及触发器的时候会有错误符号为1418错误。

[Err] 1418 - 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

or

SET GLOBAL log_bin_trust_function_creators=1