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 concern the user couldn’t be given the SUPER privilege hence setting the log_bin_trust_routine_creators=1 fix the error.

SET GLOBAL log_bin_trust_routine_creators = 1;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.