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
“
![](https://i0.wp.com/lynxbee.com/wp-content/uploads/2021/10/mysql_db_error.png?resize=897%2C353&ssl=1)
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.