介绍一下在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';