Windows 局域网连接docker数据库

蔚落 2023-02-15 05:23 137阅读 0赞

### 目标：局域网有台WindowsA机器安装了docker（测试环境），想要在另一台机器上连接A机器docker数据库（如mysql，MongoDB） ###

## 解决办法：Nginx反向代理 ##

在Nginx配置文件（conf/nginx.conf）最后添加：

stream {
    upstream mysqlsocket {
    hash $remote_addr consistent;
    server 192.168.99.100:3307 weight=5 max_fails=3 fail_timeout=30s;
    }
    server {
    listen 3307;
    proxy_connect_timeout 1s;
    proxy_timeout 3s;
    proxy_pass mysqlsocket;
    }
    upstream mongosocket {
    hash $remote_addr consistent;
    server 192.168.99.100:27017 weight=5 max_fails=3 fail_timeout=30s;
    }
    server {
    listen 3308;
    proxy_connect_timeout 1s;
    proxy_timeout 3s;
    proxy_pass mongosocket;
    }
    }

upstream mysqlsocket：指向docker虚拟机的mysql连接地址

upstream mongosocket：指向docker虚拟机的MongoDB连接地址

server {
    listen 3307;
    proxy_connect_timeout 1s;
    proxy_timeout 3s;
    proxy_pass mysqlsocket;
    }

本机3307指向mysqlsocket即指向docker虚拟机的mysql连接地址

server {
    listen 3308;
    proxy_connect_timeout 1s;
    proxy_timeout 3s;
    proxy_pass mongosocket;
    }

本机3308指向mongosocket即指向docker虚拟机的MongoDB连接地址

结果：

mysql：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIxNDU0OTcz_size_16_color_FFFFFF_t_70][]

看到本机ip是192.168.1.3，然后用Navicat连接192.168.1.3的3307端口，连接成功；

MongoDB：

![20200604164438351.png][]

也成功了，告辞！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIxNDU0OTcz_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200604164336675.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIxNDU0OTcz,size_16,color_FFFFFF,t_70
[20200604164438351.png]: https://img-blog.csdnimg.cn/20200604164438351.png