MySQL中用户授权以及删除授权的方法

　shell> mysql --user=root mysql
　　mysql> GRANT ALL PRIVILEGES ON . TO monty@localhost
　　IDENTIFIED BY 'something' WITH GRANT OPTION;
　　mysql> GRANT ALL PRIVILEGES ON . TO monty@"%"
　　IDENTIFIED BY 'something' WITH GRANT OPTION;
　　mysql> GRANT RELOAD,PROCESS ON . TO admin@localhost;
　　mysql> GRANT USAGE ON . TO dummy@localhost;

GRANT privileges ON databasename.tablename TO 'username'@'host'

GRANT SELECT, INSERT ON test.user TO 'pig'@'%'; 
GRANT ALL ON . TO 'pig'@'%';

GRANT privileges ON databasename.tablename TO 'username'@'host' WITH GRANT OPTION;

SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');

SET PASSWORD = PASSWORD("newpassword");

SET PASSWORD FOR 'pig'@'%' = PASSWORD("123456");

REVOKE privileges (columns) ON what FROM user