ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled

You could occasionally get the following problem when working with triggers or moving data between RDS instances.

“ERROR 1419 (HY000): 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)”

In these cases, alter the log_bin_trust_function_creators value in the custom DB parameter group to 1.

This allows functions, procedures, and triggers on your DB instance.

Note that if you set log_bin_trust_function_creators to 1, unsafe events may be sent to the binary log.

Leave a Reply