首页 > 数据库 >mysql报错This function has none of DETERMINISTIC. NO SOL or READS SOL DATA...

mysql报错This function has none of DETERMINISTIC. NO SOL or READS SOL DATA...

时间:2022-12-05 09:11:56浏览次数:49  
标签:function bin creators log SOL 报错 trust

是因为 存储过程/存储函数在创建时 与 开启慢查询日志冲突了
解决冲突:
临时解决:开启log_bin_trust_function_creators

show variables like '%log_bin_trust_function_creators%';
set global log_bin_trust_function_creators=1;

永久解决:
/etc/my.cnf
[mysqld]

log_bin_trust_function_creators=1

标签:function,bin,creators,log,SOL,报错,trust
From: https://www.cnblogs.com/zhenhunfan2/p/16951432.html

相关文章