怎么远程访问数据库

import paramiko
import pymysql

# SSH连接信息
ssh_host = 'your_ssh_host'
ssh_port = 22
ssh_user = 'your_ssh_user'
ssh_password = 'your_ssh_password'

# 数据库连接信息
db_host = '127.0.0.1'  # 本地地址，通过SSH隧道转发
db_port = 3306
db_user = 'your_db_user'
db_password = 'your_db_password'
db_name = 'your_db_name'

# 创建SSH客户端
ssh_client = paramiko.SSHClient()
ssh_client.set_missing_host_key_policy(paramiko.AutoAddPolicy())

# 连接SSH服务器
ssh_client.connect(ssh_host, ssh_port, ssh_user, ssh_password)

# 创建SSH隧道
transport = ssh_client.get_transport()
transport.open_channel("direct-tcpip", (db_host, db_port), ('localhost', 0))

# 连接数据库
conn = pymysql.connect(host='localhost', port=transport.local_bind_port,
                       user=db_user, password=db_password, db=db_name)

# 执行查询
cursor = conn.cursor()
cursor.execute("SELECT * FROM your_table")
results = cursor.fetchall()

for row in results:
    print(row)

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