MySQL 数据库GRANT~关于授权IP端的授权

进入MYSQL数据库
use mysql

添加 授权192.168.*.* 的用户root可以访问所有服务器的数据库；
grant all privileges on *.* to 'root'@'192.168.%.%' identified by 'pure111@111'  with grant option;

刷新执行
flush privileges;

查看信息（是否OK）
select Host,User from user;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'120.111.%.%' IDENTIFIED BY 'pure111@1119' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'202.111.%.%' IDENTIFIED BY 'pure111@111' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'202.111.111.111' IDENTIFIED BY 'pure111@111' WITH GRANT OPTION;

显示数据库名称
show databases;

show tables；

 

MySQL对用户登录ip段授权的方法

172.16.1.0/24

GRANT ALL PRIVILEGES ON *.* TO test@'172.16.1.%' identified by 'test123456' 即可。

172.16.0.0/16

GRANT ALL PRIVILEGES ON *.* TO test@'172.16.%' identified by 'test123456' 即可。

MySQL针对某一类（某字段开通的）数据库授权的方法

bbs_开头的数据库

grant all on `bbs_%`.* to test@'172.16.1.3' identified by 'test123456';