This is an old revision of the document!
SQLWays Product Page - Migration to MySQL
Free Evaluation
Symptoms
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)”.
Cause
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.
Solutions
There are several solutions for the issue:
mysql> SET GLOBAL log_bin_trust_function_creators = 1;
© 1999-2019, Ispirer Systems Ltd. All Rights Reserved. Privacy Statement |