本文介绍了解决MySQL中遇到的错误1418的方法，该错误提示函数缺少DETERMINISTIC、NOSQL或READSSQLDATA声明且启用了二进制日志。提供了三种解决方案：通过SQL命令、系统启动参数及配置文件修改。
以下是引用片段：
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)
(0 ms taken)
解决方法如下：
方法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
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)
(0 ms taken)
解决方法如下：
方法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
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
