How can I enable functions, procedures, and triggers for my Amazon Relational Database Service (Amazon RDS) for MySQL instance?

You can enable functions, procedures, and triggers when binary logging is enabled without the SUPER privilege by setting the log_bin_trust_function_creators parameter to true for the DB parameter group that you create for your MySQL instance.

Note: A default DB parameter group is created if you create a DB instance without specifying a DB parameter group that you create. For more information, see Working with DB Parameter Groups.

  1. Create a DB Parameter Group.
  2. Modify the DB parameter group as follows: log_bin_trust_function_creators=1
  3. Choose Save Changes.
    Note: After you create or modify a DB parameter group, wait at least five minutes before creating your first DB instance that uses that DB parameter group.
  4. In the navigation pane, choose Instances.
  5. Choose the instance that you want to associate with the DB parameter group.
  6. Choose Instance Actions and choose Modify.
  7. Select the parameter group you want to associate with the DB instance.

The parameter group name is changed immediately, but the parameter group changes aren't applied until you reboot the instance without failover. For more information, see Rebooting a DB Instance.

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.

Published: 2015-06-29

Updated: 2018-07-25