Mysql无法创建函数错误码 1418

最新推荐文章于 2022-08-24 11:47:12 发布

永康123

最新推荐文章于 2022-08-24 11:47:12 发布

阅读量1k

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/wyongkang/article/details/123558427

版权

MySQL 错误码1418 函数创建 binlog log_bin_trust_function_creators

关键词由CSDN通过智能技术生成

mysql 专栏收录该内容

7 篇文章 1 订阅

订阅专栏

Mysql无法创建函数错误码: 1418

在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) 这个是创建函数功能未开。

解决方式

1.查看是否打开创建函数功能

show variables like '%func%';
-------------------------------------------
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | OFF   |
+---------------------------------+-------

2.开启

SET GLOBAL log_bin_trust_function_creators = 1;

3.再次查看

show variables like '%func%';
-------------------------------------------
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | ON   |
+---------------------------------+-------