mysql -u root

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON *.*
TO mrliu@localhost
IDENTIFIED BY '123456';