MySQL限制IP访问的方法

select Host,User from mysql.user;
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

select user,host from mysql.user where user='root';

update mysql.user set host='localhost' where user='root';

flush privileges; 

mysql>grant select,insert,update,create on test.* to test@'192.168.8.%' identified by '123456';

mysql>grant select,insert,update,create on test.* to test@'192.168.9.%' identified by '123456';

mysql>grant select,insert,update,create on test.* to test@'192.168.20.%' identified by '123456';

rename user test@'%' to test@'172.22.137.%';