建立新用户 CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1'; 权限管理 GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'localhost'; GRANT ALL ON *.* TO 'user1'@'localhost'; 其它办法 GRANT ALL ON *.* TO 'user2'@'localhost' IDENTIFIED BY 'pass1'; INSERT INTO user (Host,User,Password) VALUES('localhost','user3',PASSWORD('pass3')); INSERT INTO user (Host,User,Password,Select_priv,Insert_priv) VALUES('localhost','user4',PASSWORD('pass3'),'Y','Y'); 建立数据库并给予权限 create database amarokdb; grant usage on *.* to amarokuser@localhost identified by 'amarokpasswd'; grant all privileges on amarokdb.* to amarokuser@localhost ;