AWS RDS MySQL super privilege can be set up by modifying the log_bin_trust_function_creators parameter. Find out how.

At Bobcares, we offer solutions for every query, big and small, as a part of our AWS Support Services.

Let’s take a look at how our AWS Support Team is ready to help customers set up AWS RDS MySQL super privilege.

How to setup AWS RDS MySQL super privilege

MySQL super Privilege is a MySQL GRANT statement that offers certain privileges by allowing a user account to execute administrative changes as well as perform certain database table operations. In other words, it is a type of MySQL GRANT statement that supports various privilege levels like Database, Global, Column, Table, Proxy types, and Stored Routine.

To run the GRANT statement query in MySQL, we first require super privilege. The administrative privileges to implement and use the super privileges in MySQL are defined as the global level privileges. Furthermore, the super privilege in MySQL prevents unauthenticated access and permits the admin of the MySQL database server to assign rights to user accounts. As a result, MySQL super privilege is an important feature of the MySQL server.

On the other hand, AWS RDS is a managed service that does not offer SYS access or Super privileges. This prevents us from enabling function, procedure, and triggers for the AWS RDS MySQL DB instance. According to our AWS Support Techs, we can overcome this issue by setting the log_bin_trust_function_creators parameter to true in the custom database parameter group that we create for our database instance. This results in AWS RDS MySQL super privilege.

Let’s take a look at the steps in detail:

1. To begin with, we have to create a DB parameter group.
2. Then, change the DB parameter group as:

    log_bin_trust_function_creators=1
3. Next, select Save Changes.

   Our AWS Support Team recommends waiting for at least five minutes before using the database parameter group with the database instance.
4. Then, head to Databases from the navigation pane.
5. Next, select the DB instance we want to associate the DB parameter group with.
6. After that, select Actions and then choose Modify.
7. Then, choose the parameter group we want to associate with the DB instance.
8. Finally, reboot the database instance for the changes to take effect.

The above steps will helo us with AWS RDS MySQL super privilege. In fact, these steps will also help us resolve the following error:

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)

[Need assistance with another query? We are available 24/7.]

Conclusion

In a nutshell, our skilled AWS Support Engineers at Bobcares demonstrated how to set up AWS RDS MySQL super privilege.