关闭

MySQL创建方法Function错误

标签: 数据库
285人阅读 评论(0) 收藏 举报
分类:

MySQL中创建方法提示:

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)


解决方法:

1)执行:mysql> SET GLOBAL log_bin_trust_function_creators = 1;

此方法重启失败。

2)修改my.cnf文件:

在my.ini(Linux下为my.conf)文件中[mysqld]标识后加上如下代码

log-bin-trust-function-creators=1

此方法需要重启数据库


具体参照:

http://stackoverflow.com/questions/26015160/deterministic-no-sql-or-reads-sql-data-in-its-declaration-and-binary-logging-i

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场