这么长的命令记不住，怎么办!把MySQL用户操作命令记录下来了

介绍一下在MySQL操作用户的方法。其实是因为老记不住这些命令，当记事本写到博客。

创建用户

create user 'awspack'@'localhost' identified by 'password',

查看用户信息

select User,Host from mysql.user;

修改用户密码

set password for 'awspack'@'localhost'=password('password');

赋予权限

grant all on awspack.* to 'awspack'@'localhost' identified by 'password';

删除用户

drop user 'awspack'@'localhost';