mysql ip访问

例如，给username授权只能从192.168.1.1至192.168.1.255范围的IP登陆访问     test数据库的所有表     GRANT   ALL   PRIVILEGES               ON   test.*               TO   username@'192.168.1.%'             IDENTIFIED   BY   'goodsecret';     FLUSH   PRIVILEGES;

 

 

grant create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';