Sometimes the most simplest of commands can be a blocker if you do not have access to them. Today I was in a far out place with no connectivity and no way of knowing what the command for granting privileges were.
I could not find the documentation. Finally I called a colligue and asked him to google for the command.
So just to remind me the commands are
GRANT ALL PRIVILEGES ON test.* TO ‘root’@'localhost’ IDENTIFIED BY ‘goodsecret’ WITH GRANT OPTION;

The other one is :
mysqldump –add-drop-table –all-databases

Better Still the link to mysqldump command