mysql允许远程连接

grant all privileges on *.* to root@'192.168.0.1' identified by 'panyan';
flush privileges;

匹配一个网段:

grant all privileges on *.* to root@'192.168.0.%' identified by 'panyan';
flush privileges;