MySQL error when trying to create a function

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)

 

The above error can be resolved by running the following;

SET GLOBAL log_bin_trust_function_creators = 1;

[source]

 

Also, adding the following;

READS SQL DATA

just BEFORE the BEGIN statement