[Solve] MariaDB/MySql error “… you *might* want to use the less safe log_bin_trust_function_creators variable”

Hello everyone!

If your MySQL or MariaDB server return a error message like:

“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”

You can solve this issue setting the referenced variable with value 1 in your MySQL console or GUI tool:

SET GLOBAL log_bin_trust_function_creators = 1;

It’s done!