mysql中创建用户,授权,删除用户

mysql中创建用户,授权,删除用户,以创建用户名nameone 密码为pwdone为例

创建用户
create user ‘nameone’;
这相当于
create user ‘nameone’@'%’;
创建只能本地登陆的用户
create user ‘nameone’@'localhost’;

将所有权限赋值给nameone用户
grant all privileges on *.* to ‘nameone’@'localhost’ identified by ‘pwdone’;

带grant权限
grant all privileges on *.* to ‘nameone’@'localhost’ identified by ‘pwdone’ with grant option;

删除用户
drop user ‘nameone’;
相当于
drop user ‘nameone’@'%’;

删除localhost的权限
drop user ‘nameone’@'localhost’;

查询用户及对应的权限
use mysql
select user,host from user;