Home » Web Design and Development » Database » Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

When we tried to import the database using phpmyadmin, we got an error as “

MySQL said: #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

This error can be resolved by removing following lines from the database file.

DEFINER=`root`@`localhost`

Delete all occurrences of above text from the mysql database file by opening it into your favourite editor.

Leave a Comment