mysql password setting and authorization

Author：Eve Cole Update Time：2009-05-31 00:00:06

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