通过ssh代理连接内网MySQL

# coding:utf8

from sshtunnel import SSHTunnelForwarder

server = SSHTunnelForwarder(
	ssh_address_or_host=('服务器IP', 22),
	ssh_username='root',
	ssh_password='密码',
	remote_bind_address=('127.0.0.1', 3306)
)

server.start()

print("代理端口", server.local_bind_port)

conn = pymysql.connect(
    host='127.0.0.1',
    port=server.local_bind_port,
    user='',
    password='',
    db='test'
)

ssh -N -L 127.0.0.1:33060:127.0.0.1:3306 root@114.215.156.11
本地33060端口映射服务器3306端口