mysql 密码设置与授权

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