                        课程
                    
                        /数据库
                        
                            /MySQL
                        
                        /与MySQL的零距离接触

ERROR 1418 (HY000):

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)

爱吃鳄鱼的斑马

2015-04-30

源自：与MySQL的零距离接触 7-3

关注问题我要回答

978

操作

收起

2 回答

海布里小松鼠
2015-09-10

我也遇到了，百度解决，应该是创建函数功能被禁用了吧。解决方法见上！

0 回复有任何疑惑可以回复我~

收起回答

海布里小松鼠
2015-09-10

1.mysql> set global log_bin_trust_function_creators = 1;
2. 系统启动时 --log-bin-trust-function-creators=1
3. 在my.ini(linux下为my.conf)文件中 [mysqld] 标记后加一行内容为 log-bin-trust-function-creators=1