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';