You do not have the SUPER Privilege and Binary Logging is Enabled1 min read

Prabhin Prabharkaran Administrator
DevOps Engineer

He is a Technical professional. He is a person who loves to share tricks and tips on the Internet. He Posts what he does!

follow me

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.

OPTION 1
Step 1: Login to MYSQL server.

mysql -u USERNAME -p

Stepm 2: Set the log_bin_trust_function_creators value to 1

set global log_bin_trust_function_creators=1;

Perform OPTION 1, if you are not using any services like AWS RDS, otherwise follow OPTION 2.

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”.

© 2019, Techrunnr. All rights reserved.

#1
#2
#3
Questions Answered
Articles Written
Overall Points

Related posts

Leave a Reply