Mysql restore the dump getting error access denied; you need (at least one of) the SUPER privilege(s) for this operation

If you face this error “Access denied; you need (at least one of) the SUPER privilege(s) for this operation” while restoring the SQL dump in the database with Mysql utility. Then you have problem with the DEFINER statement present in procedures or functions present in dumps.

In you dump file:

CREATE DEFINER='hr'@'localhost' PROCEDURE p1()
BEGIN
  select * from employee;
END;

You have to remove the DEFINER from the procedure statements as solution:

CREATE PROCEDURE p1()
BEGIN
  select * from employee;
END;

But for large dump file having multiple procedures and function. its better while taking dump from MYSQLDUMP utility use the –skip-definer to remove the definer from the procedure while generating the dump

mysqldump --skip-definer -h localhost -u user -p yourdatabase

With DBeaver has same options you can use while taking dump