mysql - 报错 This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled

1.报错

完整报错信息

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)

 

 

 

2.解决

执行

set global log_bin_trust_function_creators=TRUE;

即可