You do not have the SUPER Privilege and Binary Logging is Enabled1 min read
You do not have the SUPER Privilege and Binary Logging is Enabled
The error arises when you try to import the function or trigger containing dangerous statements that make changes in the database.
Step 1: Login to MYSQL server.
Perform OPTION 1, if you are not using any services like AWS RDS, otherwise follow OPTION 2.
Step 1: Login to AWS Account
Step 2: Select your RDS database and select the parameter group attached to it.
Step 3: Create a new parameter group and choose your version of MYSQL. Edit the parameter by searching “log_bin_trust_function_creators”
Step 4: Save the changes.
Step 5: Open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Modify”.
Step 6: Select the just created Parameter Group and enable “Apply Immediately”.
Step 7: Click on “Continue” and confirm the changes.
Step 8: Wait for the “Modifying” operation to be completed.
Step 9: Again, open the “Instances” tab. Expand your MySQL instance and expand “Instance Action” tab and select “Reboot”.