Access denied; you need (at least one of) the SUPER privilege(s) RDS AWS *SOLVED*

February 5, 2018 Leave a comment

The MySQL server provided by RDS does not allow a DEFINER syntax for another user.

Solution

sed -E ‘s/DEFINER=`[^`]+`@`[^`]+`/DEFINER=username/g’ store.sql > storefix.sql

 

Leave a Reply

Your email address will not be published. Required fields are marked *