MySQL 使用小贴士

建立新用户

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 ;