MySQL-用户与权限

 

 

 

 

 

 

use mysql;

select host,user,authentication_string   from user;
select * from host;
select * from db;

#创建账号sa01 @'%'表示可以连接的任意客户端
create  user 'sa01'@'%' identified by 'mima';
#然后赋予权限，将SDS数据库里所有对象的所有权限赋予账号sa相当于SQL SERVER中的db_ower
grant  all privileges  on SDS.* to 'sa01'@'%';

#收回权限
revoke  select  on   SDS.*  from    'sa01';

#权限修改生效
flush privileges;

#查看账号权限
show grants for 'sa01';

#回收所有权限
revoke all,grant option from 'sa01'@'%';

#删除用户
drop user 'sa01';

delete from  mysql.user  where user='sa01';