RDS MySQL Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation rds

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.

That's all…