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

shell> mysql --user=root mysql 
mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('something'), 
        'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y') 
mysql> INSERT INTO user VALUES('%','monty',PASSWORD('something'), 
        'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y') 
mysql> INSERT INTO user SET Host='localhost',User='admin', 
         Reload_priv='Y', Process_priv='Y'; 
mysql> INSERT INTO user (Host,User,Password) 
            VALUES('localhost','dummy',''); 
mysql> FLUSH PRIVILEGES;