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')
第一句增加了一個(gè)admin用戶授權(quán)通過本地機(jī)（localhost)訪問，密碼“something”。第二句則是授與admin用戶從任何其它主機(jī)發(fā)起的訪問（通配符％）。
當(dāng)沒有用戶 admin mysql 會(huì)自動(dòng)添加此用戶