mysql ssh分页

import pymysql
import paramiko

# SSH连接配置
ssh_host = 'your_ssh_host'
ssh_port = 22
ssh_user = 'your_ssh_user'
ssh_password = 'your_ssh_password'

# MySQL连接配置
mysql_host = 'localhost'
mysql_user = 'your_mysql_user'
mysql_password = 'your_mysql_password'
mysql_db = 'your_mysql_db'

# 创建SSH连接
ssh_client = paramiko.SSHClient()
ssh_client.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh_client.connect(ssh_host, ssh_port, ssh_user, ssh_password)

# 创建MySQL连接
mysql_conn = pymysql.connect(host=mysql_host,
                             user=mysql_user,
                             password=mysql_password,
                             db=mysql_db,
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

# 分页查询
page_size = 10
page_number = 2

# 计算偏移量
offset = (page_number - 1) * page_size

# 执行查询
with mysql_conn.cursor() as cursor:
    sql = f"SELECT * FROM table_name LIMIT {page_size} OFFSET {offset}"
    cursor.execute(sql)
    result = cursor.fetchall()

# 打印结果
for row in result:
    print(row)

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