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

Issue:

MySQL error while importing dump:

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

Solution:

cat my_db_dump.sql | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | mysql -h db_host -u db_user -p db_pwd

[e-mail]