在mysql 中创建任意函数,总是出现这个错误。是什么原因啊?? 70
Error Code: 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)
我有更好的答案
推荐于2017-11-25 12:13:50 最佳答案
解决方法如下: 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