mysql_报错1418

时间:2023-12-19 08:24:26

报错如下:

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_报错1418

说数据安全有在的危险,然后关于master和slave的关系,具体的不太了解,但是查到了方法,

详见:https://blog.csdn.net/antrychme/article/details/81807407

和关于解释master和slave的关系:https://www.cnblogs.com/jirglt/p/3549047.html

具体及解决方法:

 查看参数:show variables like 'log_bin_trust_function_creators';

一般是off

然后输入

set global log_bin_trust_function_creators=1;

你就可以创建函数了,如果想改回默认的,把1 改为0 就好