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; 刷新权限表使其设置生效
posted on 2018-11-01 11:24 LEON001028 阅读(9190) 评论(0) 编辑 收藏 举报