Last Updated: February 25, 2016
·
4.283K
· tralamazza

create triggers on Amazon RDS like a boss

Before you go on with your seppuku try setting logbintrustfunctioncreators in your DB parameter group.

First download the rds command line tools, then execute the following <strike>magic</strike> command:

rds-modify-db-parameter-group mysql-default --parameters "name=log_bin_trust_function_creators, value=on, method=immediate" --region eu-west-1 -I AWS_ACCESS_KEY_ID -S AWS_SECRET_ACCESS_KEY

note: Be sure to set your aws region accordingly :)