Error importing MySQL RDS or Aurora DB with functions or views
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
Congratulations @johncnx! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Do not miss the last post from @steemitboard:
Vote for @Steemitboard as a witness to get one more award and increased upvotes!