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