mysql ssh外网访问

import mysql.connector
from sshtunnel import SSHTunnelForwarder

# SSH隧道配置
ssh_host = 'remote_host'
ssh_port = 22
ssh_username = 'user'
ssh_password = 'password'

# MySQL配置
mysql_host = 'localhost'
mysql_port = 3306
mysql_user = 'db_user'
mysql_password = 'db_password'
mysql_database = 'db_name'

# 创建SSH隧道
with SSHTunnelForwarder(
    (ssh_host, ssh_port),
    ssh_username=ssh_username,
    ssh_password=ssh_password,
    remote_bind_address=(mysql_host, mysql_port)
) as tunnel:
    # 创建MySQL连接
    conn = mysql.connector.connect(
        host='127.0.0.1',
        port=tunnel.local_bind_port,
        user=mysql_user,
        password=mysql_password,
        database=mysql_database
    )

    # 执行查询
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM table_name")
    results = cursor.fetchall()
    for row in results:
        print(row)

    # 关闭连接
    cursor.close()
    conn.close()