参考 : 如何通过nginx代理实现外网访问内网mysql或oracle数据库_nginx 代理mysql-CSDN博客 

user  nginx;
worker_processes  auto;

error_log  /var/log/nginx/error.log notice;
pid        /var/run/nginx.pid;


events {
    worker_connections  1024;
}

stream {
    upstream mysql {
        server 192.168.1.2:3306;
    }

    server {
        listen  3306;# 反向代理后监听的端口
        proxy_connect_timeout 1s;
        proxy_timeout 3s;
        proxy_pass mysql;
    }
}

http {
    include       /etc/nginx/mime.types;
    default_type  application/octet-stream;

    log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for"';

    access_log  /var/log/nginx/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    keepalive_timeout  65;

    #gzip  on;

    include /etc/nginx/conf.d/*.conf;
}

注 : 多个端口的话写多个server即可, docker部署记得放开端口, 如下多个端口

user  nginx;
worker_processes  auto;

error_log  /var/log/nginx/error.log notice;
pid        /var/run/nginx.pid;


events {
    worker_connections  1024;
}

stream {

    server {
        listen  3306;# 反向代理后监听的端口
        proxy_connect_timeout 1s;
        proxy_timeout 3s;
        proxy_pass 192.168.1.2:3306;
    }

    server {
        listen  3307;# 反向代理后监听的端口
        proxy_connect_timeout 1s;
        proxy_timeout 3s;
        proxy_pass 192.168.1.3:3307;
    }

    server {
        listen  3308;# 反向代理后监听的端口
        proxy_connect_timeout 1s;
        proxy_timeout 3s;
        proxy_pass 192.168.1.2:3308;
    }
}

http {
    include       /etc/nginx/mime.types;
    default_type  application/octet-stream;

    log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for"';

    access_log  /var/log/nginx/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    keepalive_timeout  65;

    #gzip  on;

    include /etc/nginx/conf.d/*.conf;
}