Mysql创建或导入函数时报错

友情提醒:本文最后更新于 1706 天前,文中所描述的信息可能已发生改变,请谨慎使用。

在MySQL创建或者导入用户自定义函数时,报出以下错误:

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_creators variable)

这是因为有一个安全参数没有开启,log_bin_trust_function_creators 默认为0,是不允许function的同步的,开启这个参数,就可以创建成功了。

mysql> show variables like '%fun%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | OFF   |
+---------------------------------+-------+
1 row in set (0.00 sec)

mysql> set global log_bin_trust_function_creators=1;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%fun%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | ON    |
+---------------------------------+-------+
1 row in set (0.00 sec)

原文链接:
https://blog.csdn.net/seteor/article/details/17783477

上一篇:Django3.0开发“'X-Frame-Options' to 'deny'”报错

下一篇:使用OpenCV定位小图在大图中的位置