Error importing MySQL RDS or Aurora DB with functions or views
Words
41
Reading
1 min
Listen
Play
9y
If you're receiving the following error message:
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
You need to remove DEFINER= This can be done manually or using the SED command below
sed 's/\sDEFINER=[^]+@[^]+//' -i dumpfile.sql