Solution to 1418 error when creating a function in mysql

Copy codeThe Code is as follows:
Error Code: 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)
(0 MS taken)

Analysis:
According to the system prompt, the cause of this error may be a security configuration. The log_bin_trust_function_creators parameter in the manual is 0 by default, and function synchronization is not allowed, generally, when configuring repliaction, we forget to pay attention to this parameter. In this way, after the master updates the funtion, slave reports an error and slave stoped.
Processing Process:
Log on to the mysql database
> Set global log_bin_trust_function_creators = 1;
> Start slave;
Tracking mysql startup logs. slave runs normally and the problem is solved.