What are the minimum persmission required to restore mysql dump
For normal database restore operations, the MySQL database user (which you pass as an argument into the mysqldump command) will needs privileges related to:


STRUCTURE (Schema)
DATA manipulation


For common STRUCTURE operations the user typically will need:


DROP 
CREATE
ALTER
TRIGGER


DATA privileges typically should be

SELECT, INSERT, UPDATE and DELETE.


Importantly database structure administration privelege GRANT can be revoked.
By starting with this limited set and then adding privileges on an as needed basis you are improving the containment policies.