连接堡垒机数据库免费工具

import paramiko
import pymysql

# 配置SSH隧道
ssh_host = 'bastion_host_ip'
ssh_port = 22
ssh_user = 'ssh_username'
ssh_password = 'ssh_password'

# 配置数据库连接
db_host = 'database_host_ip'
db_port = 3306
db_user = 'db_username'
db_password = 'db_password'
db_name = '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()
local_port = 3307
transport.request_port_forward('', local_port)

# 连接数据库
db_connection = pymysql.connect(host='127.0.0.1', port=local_port, user=db_user, password=db_password, db=db_name)

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

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

print(results)