ssh mysql图片类型

import paramiko
import pymysql
from PIL import Image
from io import BytesIO

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

# MySQL连接配置
mysql_host = 'your_mysql_host'
mysql_port = 3306
mysql_user = 'your_mysql_user'
mysql_password = 'your_mysql_password'
mysql_db = 'your_mysql_db'

# 通过SSH连接到服务器
ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect(ssh_host, ssh_port, ssh_username, ssh_password)

# 创建MySQL连接
mysql_conn = pymysql.connect(host=mysql_host, port=mysql_port, user=mysql_user, password=mysql_password, db=mysql_db)

# 查询图片数据
cursor = mysql_conn.cursor()
cursor.execute("SELECT image_data FROM images WHERE id = 1")
result = cursor.fetchone()

# 处理图片数据
if result:
    image_data = result[0]
    image = Image.open(BytesIO(image_data))
    image.show()

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