创建mysql帐户及增加权限

创建账户３种方法：帐户名：username  密码：pwd

1、create user 'username'@'localhost' identified by 'pwd';

　　这种方法创建完后没权限，增加所有权限：grant all privileges on *.* to 'username'@'localhost'；

2、grant all privileges on *.* to 'username'@'localhost'　identified by 'pwd' with grant option;这种方法创建完后有所有权限；

3、直接在user表中插入一条数据：

shell> mysql

shell>use mysql

mysql>insert into user values('localhost','username',password('pwd'),

'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');