                        課程
                    
                        /數(shù)據(jù)庫
                        
                            /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

關(guān)注問題我要回答

1025

操作

收起

2 回答

海布里小松鼠
2015-09-10

我也遇到了，百度解決，應(yīng)該是創(chuàng)建函數(shù)功能被禁用了吧。解決方法見上！

0 回復(fù) 有任何疑惑可以回復(fù)我~

收起回答

海布里小松鼠
2015-09-10

1.mysql> set global log_bin_trust_function_creators = 1;
2. 系統(tǒng)啟動時 --log-bin-trust-function-creators=1
3. 在my.ini(linux下為my.conf)文件中 [mysqld] 標(biāo)記后加一行內(nèi)容為 log-bin-trust-function-creators=1