you might want to use the less safe log_bin_trust_function_creators variable问题解决

自由软件开发者

于 2022-07-21 11:02:34 发布

阅读量500

点赞数

CC 4.0 BY-SA版权

分类专栏：网-狐系列产品问题解决文章标签： tomcat java

本文链接：https://blog.youkuaiyun.com/fittec/article/details/125907924

网-狐系列产品问题解决专栏收录该内容

90 篇文章 ¥99.90 ¥299.90

订阅专栏

超级会员免费看

在尝试创建MySQL函数时遇到'you *might* want to use the less safe log_bin_trust_function_creators variable'错误。通过在配置中添加特定行，可以成功解决此问题并允许函数创建。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql创建函数报: you *might* want to use the less safe log_bin_trust_function_creators variable错误:

添加下面这行,问题解决

-- 创建函数数必须执行下面这行,不然无法创建
SET GLOBAL log_bin_trust_function_creators = 1;

函数创建成功

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

自由软件开发者

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
打赏
打赏
打赏举报

举报

专栏目录

订阅专栏

you *might* want to use the less safe log_bin_trust_function_creators variable

01-21

恢复MySQL数据库创建存储过程是遇到错误 you *might* want to use the less safe log_bin_trust_function_creators variable 需要执行 SET GLOBAL log_bin_trust_function_creators = 1; 您可能感兴趣的文章:完美解决node.js中使用https请求报CERT_UNTRUSTED的问题IntelliJ安装并使用Rust IDE插件在PHP程序中使用Rust扩展的方法python实现封装得到virustotal扫描结果python

MySQL you *might* want to use the less safe log_bin_trust_function_creators variable

weixin_30652271的博客

05-25

524

因为在打开日志文件情况下执行以前建立的自定义函数报错详细分析如下: 1 .调用自定义函数 mysql> select sp_function_dbdh_three(); #以前自定义的函数 2. 报错信息: ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO ...

参与评论您还未登录，请先登录后发表或查看评论

mysql you *might* want to use the less safe log_bin_trust_function_creators variable

Meta39的博客

05-12

1070

此函数在其声明中没有确定性、无SQL或读取SQL数据，并且启用了二进制日志记录（您可能希望使用不太安全的log_bin_trust_function_creators变量）。新增完自定义函数以后关闭它。开启log_bin_trust_function_creators SET GLOBAL log_bin_trust_function_creators = 1; 关闭log_bin_trust_function_creators SET GLOBAL log_bin_trust_function_c.

definedThis 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)

热门推荐

一火的专栏

08-22

1万+

解决方法：执行SET GLOBAL log_bin_trust_function_creators = 1; 具体说明如下：在打开日志文件情况下执行以前建立的自定义函数报错详细分析如下: 1 .调用自定义函数 mysql> select sp_function_dbdh_three(); #以前自定义的函数 2. 报错信息: ER...

MySQL 创建函数报错 you might want to use the less safe log_bin_trust_function_creators variable

07-13

1121

这是我们开启了bin-log, 我们就必须指定我们的函数是否是 1、DETERMINISTIC 不确定的 2、NO SQL 没有SQl语句，当然也不会修改数据 3、READS SQL DATA 只是读取数据，当然也不会修改数据 4、MODIFIES SQL DATA 要修改数据 5、CONTAINS SQL 包含了SQL语句其中在function里面，只有 DETERMINISTIC, NO SQL 和 READS SQL DATA 被支持。如果我们开启了 bin-log, 我们就必须为我们的functi

MySQL you *might* want to use the less safe log_bin_trust_function_creators variable

huangbaokang的博客

09-17

451

报错信息： ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQ L DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_tr...

mysql编写函数带有分号报错：you *might* want to use the less safe log_bin_trust_function_creators variable

chenzhong2010的博客

06-05

682

具体错误信息： ERR] 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) 解决办法： select @@global.log_bin_trust_funct

[MySQL] you *might* want to use the less safe log_bin_trust_function_creators variable

weixin_34418883的博客

08-26

364

mysql创建function函数报1418-- *might* want to use the less safe log_bin_trust_function_creators variable

邪小新的博客

02-21

364

mysql报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)

解决：you *might* want to use the less safe log_bin_trust_function_creators variable

04-14

2207

报错: 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) 是...

you *might* want to use the less safe log_bin_trust_function_creators variable问题解决

you might want to use the less safe log_bin_trust_function_creators variable问题解决