mysql建立函数是报错Error 1418: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA

在mysql建立函数时报错：

Error 1418: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled

解决办法：

SET @@global.log_bin_trust_function_creators='ON';

SHOW VARIABLES LIKE 'log_bin_trust_function_creators';

在mysql中执行，然后重新建立函数