参考 : 如何通过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;
}