mysql配置允许内网机器连接

 

执行如下命令行：

 

GRANT ALL PRIVILEGES ON *.* TO 'myusername'@'192.168.1.%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; flush privileges;

 

192.168.1.% 指允许该网段的全部机器