This is a peculiar error with Mariadb on RDS, this problem does not happen if you select the MySQL or Aurora Engine. If you try to run a GRANT ALL ON query you get an error like
Category Archives: AWS RDS
AWS RDS You do not have the SUPER Privilege and Binary Logging is Enabled
When importing a mysql database dump to RDS you receive this error “You do not have the SUPER Privilege and Binary Logging is Enabled”. This usually happens when your database has views or triggers defined. Although MySQL/Mariadb/Aurora RDS supports them but they are disabled by default. Lets see how we can enable them.