SQLException for SQL []; SQL state [HY000]; error code [1418]

Error: 1418 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_ROUTINE)
Message: 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)

 

SHOW VARIABLES LIKE '%func%';

SET GLOBAL log_bin_trust_function_creators=1;

 

 

SHOW VARIABLES LIKE '%max_allowed_packet%';

SET GLOBAL max_allowed_packet = 2*1024*1024*16;

转载于:https://www.cnblogs.com/china2k/p/5025735.html