入站
![img_95bbe49106fc5d9a5322d740a9e3e5b0.png](https://yqfile.alicdn.com/img_95bbe49106fc5d9a5322d740a9e3e5b0.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
![img_332417b6309bda449c4bc65cdaf3ecad.png](https://yqfile.alicdn.com/img_332417b6309bda449c4bc65cdaf3ecad.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
出站
![img_06dddd62d001801dd5aa155f35abbf0b.png](https://yqfile.alicdn.com/img_06dddd62d001801dd5aa155f35abbf0b.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
![img_9fa1cb81f4f591d2aaf176f533f112c9.png](https://yqfile.alicdn.com/img_9fa1cb81f4f591d2aaf176f533f112c9.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
有些时候我们设置好入站出站规则就可以了进行访问了,可是有的时候依然不能进行访问,那么我们就需要做下面的事情了,也就是对MySQL进行设置一下访问权限
打开Mysql控制台
输入:
use mysql;
show tables;
会出现如下显示
image.png
输入:
select host from user;
update user set host = '%' where user = 'root';
出现如下显示,就证明你已经将默认的localhost修改为%,也就是自动识别
image.png
重启MySQL服务
![img_a8abd49d79bbc14c85240013c6058e66.png](https://yqfile.alicdn.com/img_a8abd49d79bbc14c85240013c6058e66.png?x-oss-process=image/resize,w_1400/format,webp)
image.png