MySQL rds having rds_superuser_role getting error "Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation"

It appears that you’re encountering a permissions error despite having the rds_superuser_role. This role in Amazon RDS for MySQL does have some limitations, which may restrict the use of certain privileges typically accessible with a standalone MySQL instance, like SUPER or SYSTEM_VARIABLES_ADMIN.

To resolve this, review the relevant documentation for guidance on managing privileges and understanding specific limitations within RDS environments:

• Common DBA Tasks in Amazon RDS
• Master User Privileges for RDS instances
• How to Duplicate a Master User in MySQL for Amazon RDS

These resources offer insights into the permissions model for RDS MySQL and will help you adjust your setup within the boundaries of AWS’s managed database service. If additional privileges are required, consider using Amazon Aurora MySQL, which provides more extensive privileges for similar use cases.