# 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端口