python ssh登录mysql

import paramiko
import mysql.connector

# SSH连接配置
ssh_host = 'your_ssh_host'
ssh_port = 22
ssh_username = 'your_ssh_username'
ssh_password = 'your_ssh_password'

# MySQL连接配置
mysql_host = 'localhost'
mysql_user = 'your_mysql_user'
mysql_password = 'your_mysql_password'
mysql_database = 'your_mysql_database'

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

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

# 创建MySQL连接
mysql_conn = mysql.connector.connect(
    host=mysql_host,
    user=mysql_user,
    password=mysql_password,
    database=mysql_database
)

# 创建游标
cursor = mysql_conn.cursor()

# 执行SQL查询
query = "SELECT * FROM your_table"
cursor.execute(query)

# 获取结果
results = cursor.fetchall()
for row in results:
    print(row)

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