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';
