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