On the import of the function or trigger to MySQL database, the following error arises: “You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)”.
The error arises when you try to import the function or trigger containing dangerous 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.
There are several solutions for the issue:
mysql> SET GLOBAL log_bin_trust_function_creators = 1;
© 1999-2014, Ispirer Systems Ltd.
All Rights Reserved. Privacy Statement