ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled

MariaDB Error:

ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_routine_creators variable)

Cause:

The user who is executing the create function doesn’t have the required SUPER privilege.

Solution:

AS for security concerns, the user couldn’t be given the SUPER privilege hence setting the log_bin_trust_routine_creators=1 to fix the error.

SET GLOBAL log_bin_trust_routine_creators = 1;