mysql 密碼設置與授權_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';