Amazon RDS super user privilege

Question

I have created Amazon RDS instance, but can't create stored procedures in it because I am missing super user privilege. How do I get super user privileges?

Instance: MySQL 5.7.11

Answer 1

You will not get super privilege in AWS RDS, but there is a way to disable binary logging (thereby removing the need to have SUPER privileges for creating triggers). This is done by setting the variable log_bin_trust_create_function_creators to 1.

1. Create a new RDS Parameter Group. Alternatively, you may modify your current parameter group (if its not the default parameter group) and skip steps 3-5.
2. Change the value of log_bin_trust_create_function_creators to 1 for that parameter group
3. Also change any parameters that have non-default values in the parameter group that your RDS instance is currently using. This is necessary because an RDS instance can only be associated with one parameter group
4. Modify your RDS instance so that it uses your new parameter group
5. Wait for the parameter group change to show in the event log
6. Reboot the RDS instance. log_bin_trust_create_function_creators is labeled as dynamic vairable, and therefore shouldn't require a restart, but I have always needed to reboot the RDS instance for the change to take effect. Perhaps there is another way but I haven't found it.