The function has none of the DETERMINISTIC, NO SQL, or READS SQL DATA
If you got this error:
ERROR 1419 (HY000) at line 1140: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
The error message is pretty clear. Binary logging needs to be enabled in order to restore the functions. There are two ways for doing this:
- Execute the following command into the MySQL console:
1SET GLOBAL log_bin_trust_function_creators = 1; - Add the line to the mysql.ini configuration file
1log_bin_trust_function_creators = 1
Source : Logikdev