Linux系统访问Windows（本机）的Navicat数据库

向右看齐 2024-04-03 07:21 72阅读 0赞

**目录**

第一步: 防火墙添加入站规则 把3306端口公开

第二步: navicat中操作

第三步: 修改项目中 druid.properties 配置文件

如何查看IP地址呢?

--------------------

## **第一步: 防火墙添加入站规则** **把3306端口公开** ##

![75d06565ba2b4b639f443594a1e67af5.png][]

![dfc4a54e693e45bca342e5ece220ace2.png][]

![3a9d9d0471ff4464ab3c9e65174b3b29.png][]

![92dc102862554973a5e713cb578cefd7.png][]

![7eeea0020e6c49d18ebe7362f000d13a.png][]

![3915b79207574ad7bb596b45cd7fc8c3.png][]

![a15861e933be4f39a0be17b0c6e5ba49.png][]

![b22afad9e98f45e4a6c636fca16c0517.png][]

![f286a49f1ede44bdbf6bfb941201bc10.png][]

![1fc15cfcd984451cafb40984e68123ba.png][]

![64e25438f8be4449bafdeca63f9a45d7.png][]

点击完成即可！！！

完成之后验证一下

![b9e49e08070743c5820db44938e9cc9c.png][]

至此windows的防火墙设置完成！！！

## **第二步: navicat中操作** ##

打开navicat,在windows（本机）下创建的数据库中创建一个查询,执行下面三行:

use mysql;
    
    update user set host = '%' where user = 'root';
    
    flush privileges;

## **第三步: 修改项目中 druid.properties 配置文件** ##

![10422043c2e04774a315eed8a3a2b01d.png][]

将此处127.0.0.1改为本机IP地址,

## 如何查看IP地址呢? ##

右键点击网络图标:

![9258d65cad644d8d949cb7732e4233d9.png][]

往下滑找到:

它的值就是你本机的地址! ipv4地址：每天都会变的，如果想访问就要去改 **druid.properties 配置文件地址**

![4e798cdccc2245a39b56ad64b0cec556.png][]

去 **druid.properties** 把这个地址改一下改成本机的ipv4地址

![a2816963d036499a858691fc068078ac.png][]

启动tomcat

然后去网页访问 Linux下的IP地址:8080/war包名(项目部署名)/项目首页名

![91e280c0a22243c18e576d0643c36e6d.png][]

项目运行成功即可!!!

[75d06565ba2b4b639f443594a1e67af5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/473e90f18aa5423ea67c545933be54df.png
[dfc4a54e693e45bca342e5ece220ace2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/6b08eb3fa35c4d578af63c65453365d1.png
[3a9d9d0471ff4464ab3c9e65174b3b29.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/20db149d361845b2aac358d85de3af70.png
[92dc102862554973a5e713cb578cefd7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/ddd313db997348528506f8ee14ecda4f.png
[7eeea0020e6c49d18ebe7362f000d13a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/fe730e395dcc47e1bbb92605116d9f38.png
[3915b79207574ad7bb596b45cd7fc8c3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/c3c1621345a64040bd2b4a15d51cd3b8.png
[a15861e933be4f39a0be17b0c6e5ba49.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/0eb6c1f904404df5bea3c8f91088b3f6.png
[b22afad9e98f45e4a6c636fca16c0517.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/8fd6065556124caa8c7478ee147765cb.png
[f286a49f1ede44bdbf6bfb941201bc10.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/8e3689db08e6433b8b370c1d0cb4e95e.png
[1fc15cfcd984451cafb40984e68123ba.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/939a59498ce247e6be610a5d677bdf13.png
[64e25438f8be4449bafdeca63f9a45d7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/55abca7cb30e4c58992e55d77cf5ad14.png
[b9e49e08070743c5820db44938e9cc9c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/9ce6c70573c74eceaad4871b28aa9f71.png
[10422043c2e04774a315eed8a3a2b01d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/8def1d6d95244b858c4a46f9cf5a2ff4.png
[9258d65cad644d8d949cb7732e4233d9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/138f1353608c4780b1585821247ab567.png
[4e798cdccc2245a39b56ad64b0cec556.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/0ace87ba6e6641e9bf8d5f255df00994.png
[a2816963d036499a858691fc068078ac.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/5aa11364fc4741baba1f8f0f88e6d64c.png
[91e280c0a22243c18e576d0643c36e6d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/69a78116906f4d68834d754c82852d4e.png