Access denied; you need (at least one of) the SUPER privilege(s) for this operation rds
This is a common error that happens on restoring MySQL database dump with to RDS. Because definer format in self-hosted MySQL server does not supported by RDS.
We can resolve this problem by removing the DEFINER section from MySQL dump file.
#sed -i 's/DEFINER=[^*]*\*/\*/g' dump-file
Where dump-file need to be replaced with the name of the MySQL dump file.
Now the dump can be restored to RDS without any issues.