GRANT ALL PRIVILEGES ON *.* TO admin@localhost IDENTIFIED BY 'something' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO admin@% IDENTIFIED BY 'something' WITH GRANT OPTION;
INSERT INTO user VALUES('localhost','admin',PASSWORD('something'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
INSERT INTO user VALUES('%','admin',PASSWORD('something'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
第一句增加了一個admin用戶授權通過本地機（localhost)訪問，密碼“something”。第二句則是授與admin用戶從任何其它主機發起的訪問（通配符％）。
當沒有用戶 admin mysql 會自動添加此用戶