Name: MySQL: ERROR 1227 (42000) at line 27: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Rating: 4.3 (8799 reviews)
Author: dm8ry

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

Dmitry Romanoff - Nov 9 '23 -

- Dev Community

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

ask_dima@yahoo.com