MariaDB Error 1418 – ER_BINLOG_UNSAFE_ROUTINE

In this post, you’ll learn more about the MariaDB Error 1418 ER_BINLOG_UNSAFE_ROUTINE with the details of the error message and why you receive this error

Maria DB Error Description

MariaDB Error 1418 – ER_BINLOG_UNSAFE_ROUTINE with the sqlState HY000

Error Description for the MariaDB Error ER_BINLOG_UNSAFE_ROUTINE

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)