DEV Community

Dmitry Romanoff
Dmitry Romanoff

Posted on

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

#mysql #devops #database #howto

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
Enter fullscreen mode Exit fullscreen mode

Solution:

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

Top comments (0)

Read next

shohams profile image

When to use SQL vs NoSQL

Shani Shoham -

abhilash8 profile image

OCI - Database Cloud Metrics - #1 Basic Management Metrics

Abhilash Kumar Bhattaram -

guto profile image

Meet Datomic: the immutable and functional database.

guto -

iamjose profile image

Como funciona um Load Balance e como implementar utilizando Nginx.

José Paulo Marinho -