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

[boris1988]

Description
bin/mysql < ../../Downloads/dump.sql

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

Steps To Reproduce
1.bin/mysql < ../../Downloads/dump.sql

Expected Result
Database has imported

Actual Result
Got permission error

[rangerz]

Normally, importing database should not use root privileges.

It need to remove DEFINER from your export sql file.

ref: https://stackoverflow.com/questions/9446783/remove-definer-clause-from-mysql-dumps

cat dump.sql | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' > dump_backup.sql
# and them import again
bin/mysql < ../../Downloads/dump_backup.sql

Other option to root privileges

bin/clinotty mysql -hdb -u root -pmagento magento < ../../Downloads/dump_backup.sql

Good Luck

[boris1988]

@rangerz Thanks
This solved my issue