

应用 MySQL 时,会遇到不能创建函数的情况。出现如下错误信息:
ERROR 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函数功能:
SET GLOBAL log_bin_trust_function_creators=1;
关闭MySQL函数功能:
SET GLOBAL log_bin_trust_function_creators=0;
查看状态:


亲爱的:若该文章解决了您的问题,可否收藏+评论+分享呢?
              


 
                  
                  ![解决mysql导入报错[Err] [Dtf] 1153 - Got a packet bigger than 'max_allowed_packet' bytes With sta](/d/file/p/2021/09-30/3e51f9b812c8ca34acfb8910141b7ab1.jpg) 
                  
                   
                  
                   
                  
                  
文章评论 本文章有个评论