RDS MySQL restore error: ERROR 1227 (42000) : Access denied; you need (at least one of) the SUPER privilege(s) for this operation

ERROR 1227 (42000) : Access denied; you need (at least one of) the SUPER privilege(s) for this operation

This error happens on restoring the dump file to RDS as the cloud service doesn't provide the super user privileges. But we can resolve this by doing a simple hack on dump file.

#sed -i 's/DEFINER=[^*]*\*/\*/g' dump.sql 

Where dump.sql need to be replaced with the dump file name.

We can able to import the dump to RDS without any issues now.

That's all…