ERROR 1419 (HY000): You do not have the SUPER Privilege and Binary Logging is Enabled

<<Back to MySQL & MariaDB Main Page

ERROR 1419 (HY000): You do not have the SUPER Privilege and Binary Logging is Enabled

Cause:
The error arises when you try to import the function or trigger containing statements that make changes in the database. The error arises only if the binary logging option, which is required for the replication, is turned on for the MySQL server.
Solutions
1> grant the SUPER user privileges to the user in question
2> Set log_bin_trust_function_creators
You can set it in 2 ways
by specifying it on the server start, like: --log-bin-trust-function-creators=1  or in /etc/my.cnf file
or
by setting it to 1 through the SET GLOBAL statement, like:
mysql> SET GLOBAL log_bin_trust_function_creators = 1;