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

shell> mysql --user=root mysql 

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP 

ON bankaccount.* 


TO custom@localhost 

IDENTIFIED BY 'stupid'; 

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP 

ON expenses.* 

TO custom@whitehouse.gov 

IDENTIFIED BY 'stupid'; 

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP 

ON customer.* 

TO custom@'%' 

IDENTIFIED BY 'stupid';

英文代码

shell> mysql --user=root mysql 

mysql> INSERT INTO user (Host,User,Password) 

VALUES('localhost','custom',PASSWORD('stupid')); 

mysql> INSERT INTO user (Host,User,Password) 

VALUES('server.domain','custom',PASSWORD('stupid')); 

mysql> INSERT INTO user (Host,User,Password) 

VALUES('whitehouse.gov','custom',PASSWORD('stupid')); 

mysql> INSERT INTO db 

(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, 

Create_priv,Drop_priv) 

VALUES 

('localhost','bankaccount','custom','Y','Y','Y','Y','Y','Y'); 

mysql> INSERT INTO db 

(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, 

Create_priv,Drop_priv) 

VALUES 

('whitehouse.gov','expenses','custom','Y','Y','Y','Y','Y','Y'); 

mysql> INSERT INTO db 

(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, 

Create_priv,Drop_priv) 

VALUES('%','customer','custom','Y','Y','Y','Y','Y','Y'); 

mysql> FLUSH PRIVILEGES;

mysql> GRANT ... 

ON *.* 

TO myusername@"%.mydomainname.com" 

IDENTIFIED BY 'mypassword'; 

为了通过直接修改授权表做同样之事情，这样做： 

mysql> INSERT INTO user VALUES ('%.mydomainname.com', 'myusername', 

PASSWORD('mypassword'),...); 

mysql> FLUSH PRIVILEGES;