mysql grant配置授权
发布时间:2020-03-04 09:22:32
来源:51CTO
阅读:644
作者:wx5be582d51c2c5
栏目:云计算
新建一个用户admin1对所有的库表完全权限,允许从任何地方访问,密码设为123456
Query OK, 0 rows affected, 1 warning (0.00 sec)
语法为
grant 权限列表 on 库名.表名 用户名@“用户地址” identified by " 密码" [ with grant opion ];
mysql> grant all on . to admin2@"%" identified by "123456" with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)
all 匹配所有权限
. 匹配所有库和表
” %“ 匹配所有主机
授权用户admin3 允许对192.168.4.0/24网段访问
mysql> grant all on . to admin3@'192.168.4.0/24' identified by "123456" with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)
对用户admin4在daydb4.user1仅有查询权限 登录密码为123456
mysql> grant select on daydb4.user1 to admin4@"local