import pymysql
import paramiko
import pandas as pd
from paramiko import SSHClient
from sshtunnel import SSHTunnelForwarder
ssh_host = '198.54.xx.xx'
ssh_host_port = 21098 #Ur SSH port
ssh_username = "sshuser123" #Change this
ssh_password = "sshpassword123" #Change this
db_user = 'db user' #change this
db_password = 'password123' #change this
db = 'main_db' #The db that the user is linked to
with SSHTunnelForwarder(
(ssh_host, ssh_host_port),
ssh_username=ssh_username,
ssh_password=ssh_password,
remote_bind_address=('127.0.0.1', 3306)) as tunnel:
conn = pymysql.connect(host='127.0.0.1', user=db_user,
passwd=db_password, db=db,
port=tunnel.local_bind_port)
query = '''SELECT * from tablename;'''
data = pd.read_sql_query(query, conn)
print(data)
conn.close()
ssh -t -gL 33069:localhost:3306 198.54.x.240
在窗户上用油灰,我喜欢基蒂(叉子油灰) 添加连接和SSH隧道查看图片所以我用了一百万次的尝试和错误来解决这个问题:
如果MySql上的SSH没有任何公钥/私钥,则应使用此代码
希望这能帮助任何面临同样问题的人
相关问题 更多 >
编程相关推荐