如何使用Python通过ssh连接到mysql

pip install paramiko
pip install pymysql

import paramiko
import pymysql

ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect('SSH服务器IP地址', username='用户名', password='密码')

db = pymysql.connect(host='MySQL服务器IP地址', user='用户名', password='密码', database='数据库名称')
cursor = db.cursor()
cursor.execute('SQL命令')
result = cursor.fetchall()

for row in result:
    print(row)

import paramiko
import pymysql

# 建立SSH连接
ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect('SSH服务器IP地址', username='用户名', password='密码')

# 执行MySQL命令
db = pymysql.connect(host='MySQL服务器IP地址', user='用户名', password='密码', database='数据库名称')
cursor = db.cursor()
cursor.execute('SQL命令')
result = cursor.fetchall()

# 处理结果
for row in result:
    print(row)

# 关闭连接
cursor.close()
db.close()
ssh.close()