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

While MySQL Database trying to import & getting below error

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

Solution :: Before start to import, need to run below sed command, for database, that you want to import, here database name magento24.sql

sed 's/\sDEFINER=`[^`]*`@`[^`]*`//g' -i /var/www/html/magento24.sql

“sed command removing the DEFINER= statement from database file”

After that run MySQL Database import Command

mysql -u root -p magento24  < /var/www/html/magento24.sql

It will be working fine, Finally issue has been resolved.

Leave a Reply

Your email address will not be published. Required fields are marked *