RDS or EC2 - what’s the best option for your DB?
Markus Kaiser
51

Creating Triggers with Binary Logging Enabled Requires SUPER Privilege

Amazon RDS SUPER privileges

#1419 — 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
I am using Amazon MySQL RDS, When I try to create triggers on database, the above Error is appeared. To resolve this I got the following solution to enable the “log_bin_trust_function_creators” parameter in user defined Parameter group. I used the following aws cli command to activate it:

./rds-create-db-parameter-group — db-parameter-group-name allow-triggers — db-parameter-group-family mysql5.7 — description ‘parameter group to allow triggers’ — I=”xxxxxxx” — S=”xxxxxxxxx”

./rds-modify-db-parameter-group — db-parameter-group-name allow-triggers — parameters “name=log_bin_trust_function_creators, value=true, method=pending-reboot” — I=”xxxxxxx” — S=”xxxxxxx”

./rds-modify-db-instance — db-instance-identifier rds1 — db-parameter-group-name allow-triggers — apply-immediately — I=”xxxxxxx” — S=”xxxxxxx”

./rds-reboot-db-instance rds1 — I=”xxxxxxx” — S=”xxxxxxx”

Reference: http://getasysadmin.com/2011/06/amazon-rds-super-privileges/

However after successful execution of above procedure I am still unable to create triggers in MySQL RDS database. Still super privilege is required error is being appeared.

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.