MySQL允许某个IP网段从远程访问的方法

grant select,insert,update,create on test.* to test@'192.168.8.%' identified by '123456';     允许增删改查权限

grant all  on test.* to test@'192.168.8.%' identified by '123456';    允许所有权限

flush privileges;  刷新权限表使其设置生效