mysql 导入sql文件，出现ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL报错

最新推荐文章于 2023-11-14 17:20:14 发布
原创 最新推荐文章于 2023-11-14 17:20:14 发布 · 7.1k 阅读 · 12 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql #function

部署运行你感兴趣的模型镜像

ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL

mysql的设置默认是不允许创建函数

1、更改全局配置

      SET GLOBAL log_bin_trust_function_creators = 1;  

      有主从复制的时候 , 从机必须要设置  不然会导致主从同步失败

2、更改配置文件my.cnf  

      log-bin-trust-function-creators=1   重启服务生效

您可能感兴趣的与本文相关的镜像

Stable-Diffusion-3.5

Stable-Diffusion-3.5

图片生成
Stable-Diffusion

Stable Diffusion 3.5 (SD 3.5) 是由 Stability AI 推出的新一代文本到图像生成模型，相比 3.0 版本，它提升了图像质量、运行速度和硬件效率

mysql - 报错1418-This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration
高级前端工程师
04-09 3381
mysql，报错，linux，Navicat for MySQL，可视化工具mysql，mysql无法保存函数，MySQL保存函数就报错，只要保存函数就会出错，如何解决mysql函数保存提示错误，MySQL 创建函数报错，弹框报错，mysql错误代码1418，mysql报错解决教程，This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enable
mysql - 报错1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declarati
高级前端工程师
01-19 3180
mysql，navicat，navicat弹框报错1418错误代码，mysql使用navicat中运行函数时报错，mysql创建函数存储过程报错，mysql函数保存时报错1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declarati，如何解决mysql报错，怎么解决navicat无法进行函数保存报错，navicat进行mysql函数的保存时弹框提示，自定义函数报错[Err] 1418，mys
MySQL This function has none of DETERMINISTIC, NO SQL...错误1418 的原因分析及解决方法
热门推荐
Sky 的专栏
11-06 9万+
MySQL开启bin-log后，调用存储过程或者函数以及触发器时，会出现错误号为1418的错误: 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* wan
[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
IT382566697的专栏
06-24 1143
错误信息: [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_...
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
lxpbs8851的专栏
05-04 7948
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary mysql的设置默认是不允许创建函数 解决办法1: 执行： SET GLOBAL log_bin_trust_function_creators = 1; 不过 重启了 就失效了
自定义函数报错[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in......
u013068184的博客
10-08 5284
创建自定义函数时，发生错误。 -- ---------------------------- -- Function structure for getChildLst -- ---------------------------- DROP FUNCTION IF EXISTS `getChildLst`; DELIMITER ;; CREATE DEFINER=`root`@`%` FUNCT...
mysql 报错This function has none of DETERMINISTIC解决方案
12-16
MySQL数据库在开启二进制日志(bin-log)功能后，可能会遇到一个特定的错误：“This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled...”。...
ERROR 1418 (HY000) at line 9038: 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)
最新发布
03-26
在 MySQL 中，当启用了二进制日志记录（`binlog`），并且尝试创建或修改存储函数时，如果该函数未声明为 `DETERMINISTIC`、`NO SQL` 或 `READS SQL DATA` 属性，则会触发错误 1418。这是因为二进制日志主要用于主从...
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQ L DATA in its decla
长江某菜鸟的博客
08-30 2925
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_cr
mysql error 1418:This function has none of DETERMINISTIC, NO SQL,or READS SQL DATA in its declaratio
weixin_44359392的博客
12-10 465
在创建函数begin之前加DETERMINISTIC 或者 NOT DETERMINISTIC CREATE DEFINER = CURRENT_USER PROCEDURE NewProc() DETERMINISTIC BEGIN #Routine body goes here… END; DETERMINISTIC和NOT DETERMINISTIC指出一个子程序是否对给定的输入总是产生同样的结果。 如果没有给定任一特征，默认是NOT DETERMINISTIC，所以必须明确指定DETERMIN
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQLmysql的设置默认是不允许创建函数
IT_LL的专栏
11-14 503
mysql创建函数存储过程报错。
sql去掉html标签
不积跬步，无以至千里；不积小流，无以成江海。
09-27 810
开启-信任存储函数创建者 简单介绍一下，当二进制日志启用后，这个变量就会启用。它控制是否可以信任存储函数创建者，不会创建写入二进制日志引起不安全事件的存储函数。如果设置为0（默认值），用户不得创建或修改存储函数，除非它们具有除CREATE ROUTINE或ALTER ROUTINE特权之外的SUPER权限。 设置为0还强制使用DETERMINISTIC特性或READS SQL DATA或NO SQ...
【MySQL】运行函数时报错[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
DJames23的博客
04-11 2825
在navicat中运行函数时报错，报错信息如下： [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) 参考博客： 怎么解决执行MySQL函数时
MySQL：ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
彭世瑜的博客
04-10 2925
环境 mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.16 | +-----------+ 定义函数 -- 最简单的函数 create function foo() returns int return 10; 报错 ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS
weixin_34185364的博客
11-20 316
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...
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
kongkong的专栏
06-26 408
创建function的时候，报这个错误。
[HY000][1418] This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration
qq_43060870的博客
08-05 707
Mysql在创建函数时报如下错误： [HY000][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) 解决方法： set global log
ERROR 1418: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled
11-12
这个错误信息（ERROR 1418）在MySQL数据库中出现，通常意味着当二进制日志（Binary Logging）功能启用时，尝试创建或修改一个函数，但该函数的声明中缺少`DETERMINISTIC`, `NO SQL`, 或 `READS SQL DATA` 中的一个或...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值