Error importing MySQL RDS or Aurora DB with functions or views

in aws •  7 years ago 

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

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Congratulations @johncnx! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 2 years!

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:

The new SteemFest⁴ badge is ready
Vote for @Steemitboard as a witness to get one more award and increased upvotes!