Hi All, I set this parameters on master & slave SET GLOBAL log_bin_trust_function_creators = 1; Then i applied a script that creates procedure and function. It got created on master, but on slave i am getting below error and procedure and function are not getting created on slave.
select ROUTINE_NAME,ROUTINE_TYPE,ROUTINE_SCHEMA from routines; Empty set (0.00 sec) '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)' on query. Default database: 'reports1'. Query: 'CREATE [EMAIL PROTECTED] FUNCTION `next_day`(dt date, dn varchar(10)) RETURNS date
