MySQL Error 1418 workaround

Statement

The Stars last night

Blog:http://yestreenstars.blog.51cto.com/

This article by oneself creation, if need reprint, please indicate source, thank cooperation!

Error

ERROR 1418 (HY000) at line 1693:this function have none of deterministic, NO SQL, or READS SQL DATA in its declaration and Binary logging is enabled (*might* want to use the less safe log_bin_trust_function_creators variable)

Workaround

# Modify the/etc/my.cnf file, add a line under the [mysqld] field: log-bin-trust-function-creators=1# and then restart the Mysqld service.

This article is from the "Last Night Stars" blog, please make sure to keep this source http://yestreenstars.blog.51cto.com/1836303/1550217

MySQL Error 1418 workaround