MySQL Create function 1418 error resolution

This article is the creation of a function in MySQL "ERROR 1418" solution to the detailed analysis of the introduction, the need for friends to copy the code code below:
Error code:1418
This function has none of the deterministic, NO SQL, or reads SQL DATA in the its declaration and binary logging are enabled (you * Might* want to use the less safe log_bin_trust_function_creators variable)
(0 ms taken)

Analysis:
According to the system prompts, the cause of this error may be a security settings configuration, the search manual log_bin_trust_function_creators parameter default 0, is not allowed function synchronization, In general, when we configure repliaction, we forget to pay attention to this parameter, so that after master updates funtion, slave will report the error, then slave stoped.
Processing Process:
Login to MySQL database
> Set global log_bin_trust_function_creators = 1;
> Start slave;
Track MySQL boot log, slave normal operation, problem solving.