create user 'username'@'host' identified by 'password';
%
create user 'dog'@'localhost' identified by '123456'; create user 'pig'@'192.168.1.101_' idendified by '123456'; create user 'pig'@'%' identified by '123456'; create user 'pig'@'%' identified by ''; create user 'pig'@'%';
grant privileges on databasename.tablename to 'username'@'host'
select
,insert
,update
等,如果要授予所的权限则使用all
*
表示,如*.*
grant select, insert on test.user to 'pig'@'%'; grant all on *.* to 'pig'@'%'; grant all on maindataplus.* to 'pig'@'%';
用以上命令授权的用户不能给其它用户授权,如果想让该用户可以授权,用以下命令:
grant privileges on databasename.tablename to 'username'@'host' with grant option;
set password for 'username'@'host' = password('newpassword');
如果是当前登陆用户用:
set password = password("newpassword");
set password for 'pig'@'%' = password("123456");
revoke privilege on databasename.tablename from 'username'@'host';
privilege, databasename, tablename:同授权部分
revoke select on *.* from 'pig'@'%';
假如你在给用户'pig'@'%'
授权的时候是这样的(或类似的):grant select on test.user to 'pig'@'%'
,则在使用revoke select on *.* from 'pig'@'%';
命令并不能撤销该用户对test数据库中user表的select
操作。相反,如果授权使用的是grant select on *.* to 'pig'@'%';
则revoke select on test.user from 'pig'@'%';
命令也不能撤销该用户对test数据库中user表的select
权限。
具体信息可以用命令show grants for 'pig'@'%';
查看。
drop user 'username'@'host'
如对本文有疑问, 点击进行留言回复!!
JDBC访问数据库操作详解(四)之三层架构:以MySQL为例
MySQL 三万字精华总结 + 面试100 问,和面试官扯皮,吹牛逼!绰绰有余(一:MySql架构,数据类型,存储引擎)收藏系列!
服务器Centos部署MySql并连接Navicat过程详解
网友评论