/為struts用戶分配權(quán)限/

INSERT INTO USER(USER,PASSWORD) VALUE('struts','struts');
UPDATE USER SET PASSWORD=PASSWORD('struts') WHERE USER='struts';
GRANT ALL PRIVILEGES ON struts TO struts;
FLUSH PRIVILEGES;

/創(chuàng)建spring用戶 ，為該用戶分配spring 數(shù)據(jù)庫(kù)的所有權(quán)限/
/創(chuàng)建spring用戶/

INSERT INTO USER(HOST,USER,PASSWORD)
VALUE('localhost','spring',PASSWORD('spring'));

/為該用戶分配spring 數(shù)據(jù)庫(kù)的所有權(quán)限/

GRANT ALL PRIVILEGES ON spring.* TO spring@localhost IDENTIFIED BY 'spring';
FLUSH PRIVILEGES;

/創(chuàng)建springmvc用戶 ，為該用戶分配springmvc 數(shù)據(jù)庫(kù)的所有權(quán)限/
/創(chuàng)建springmvc用戶/

INSERT INTO USER(HOST,USER,PASSWORD)
VALUE('localhost','springmvc',PASSWORD('springmvc'));

/為該用戶分配springmvc 數(shù)據(jù)庫(kù)的所有權(quán)限/

GRANT ALL PRIVILEGES ON springmvc.* TO springmvc@'localhos IDENTIFIED BY 'springmvc' WITH GRANT OPTION; 
FLUSH PRIVILEGES;

/創(chuàng)建springmvc1用戶 ，為該用戶分配springmvc 數(shù)據(jù)庫(kù)的所有權(quán)限/
/創(chuàng)建springmvc1用戶/

INSERT INTO USER(HOST,USER,PASSWORD)VALUE('localhost','springmvc1',PASSWORD('springmvc1'));
FLUSH PRIVILEGES;

/為該用戶分配springmvc 數(shù)據(jù)庫(kù)的所有權(quán)限/

GRANT ALL PRIVILEGES ON springmvc.* TO springmvc1@'localhost' IDENTIFIED BY 'springmvc1'WITH GRANT OPTION; 
FLUSH PRIVILEGES;

/收回所有權(quán)限/

REVOKE ALL PRIVILEGES ON springmvc.* FROM springmvc1@'localhost';

/將spring用戶的create，INSERT,UPDATE,DELETE 權(quán)限收回/

REVOKE CREATE ON  spring.* FROM spring@'localhost';
FLUSH PRIVILEGES;
REVOKE INSERT,UPDATE,DELETE ON spring.* FROM spring@'localhost';
FLUSH PRIVILEGES;

/將收回的權(quán)限重新進(jìn)行授予/

GRANT CREATE,INSERT,UPDATE,DELETE ON spring.* TO spring@'localhost' IDENTIFIED BY 'spring'; 

SELECT * FROM USER;

注意: 這幾點(diǎn)很重要

（1）創(chuàng)建了用戶，需要查看mysql數(shù)據(jù)庫(kù)中mysql數(shù)據(jù)庫(kù)的user表

（2）分配了對(duì)某一或者多個(gè)數(shù)據(jù)庫(kù)的權(quán)限，應(yīng)該查詢mysql數(shù)據(jù)庫(kù)中mysql數(shù)據(jù)庫(kù)的db表

（3）分配了對(duì)某一數(shù)據(jù)庫(kù)的某一張或者幾張表的權(quán)限，應(yīng)該查詢mysql數(shù)據(jù)庫(kù)中mysql數(shù)據(jù)庫(kù)的table_pri表

（4）執(zhí)行了新用戶的分配，以及權(quán)限分配的時(shí)候，一定要進(jìn)行flush privileges的執(zhí)行，否者沒(méi)有將分配權(quán)限進(jìn)行更新，會(huì)出現(xiàn)錯(cuò)誤信息。