/*創(chuàng)建用戶*/
GRANT ALL PRIVILEGES ON *.* TO 'zhihua'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
/*OR*/
CREATE USER zhihua IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'zhihua'@'%' WITH GRANT OPTION;
除了GRANT，還可以直接用INSERT語句創(chuàng)建相同的賬戶，然后使用FLUSH PRIVILEGES告訴服務(wù)器重載授權(quán)表。
INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user SET Host='localhost',User='admin',Reload_priv='Y', Process_priv='Y';
INSERT INTO user (Host,User,Password) VALUES('localhost','dummy','');
FLUSH PRIVILEGES;
當(dāng)你用INSERT創(chuàng)建賬戶時使用FLUSH PRIVILEGES的原因是告訴服務(wù)器重讀授權(quán)表。否則，只有重啟服務(wù)器后更改方會被注意到。使用 GRANT，則不需要使用FLUSH PRIVILEGES。
/*可以訪問bankaccount數(shù)據(jù)庫，但只能從本機訪問*/
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO 'custom'@'localhost' IDENTIFIED BY 'obscure';
/*可以訪問expenses數(shù)據(jù)庫，但只能從主機whitehouse.gov訪問*/
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON expenses.* TO 'custom'@'whitehouse.gov' IDENTIFIED BY 'obscure';
/*可以訪問customer數(shù)據(jù)庫，但只能從主機server.domain訪問*/
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON customer.* TO 'custom'@'server.domain' IDENTIFIED BY 'obscure';
具體還有兩種方式，請看
LINK。