/Python/Python db access though ssh user

Python db access though ssh user

import pymysql
import paramiko
import pandas as pd
from paramiko import SSHClient
from sshtunnel import SSHTunnelForwarder
from os.path import expanduser

home = expanduser('~')
mypkey = paramiko.RSAKey.from_private_key_file(home + pkeyfilepath)
# if you want to use ssh password use - ssh_password='your ssh password', bellow

sql_hostname = 'sql_hostname'
sql_username = 'sql_username'
sql_password = 'sql_password'
sql_main_database = 'db_name'
sql_port = 3306
ssh_host = 'ssh_hostname'
ssh_user = 'ssh_username'
ssh_port = 22
sql_ip = '1.1.1.1.1'

with SSHTunnelForwarder(
        (ssh_host, ssh_port),
        ssh_username=ssh_user,
        ssh_pkey=mypkey,
        remote_bind_address=(sql_hostname, sql_port)) as tunnel:
    conn = pymysql.connect(host='127.0.0.1', user=sql_username,
            passwd=sql_password, db=sql_main_database,
            port=tunnel.local_bind_port)
    query = '''SELECT VERSION();'''
    data = pd.read_sql_query(query, conn)
    conn.close()

Source: stackoverflow.com

Similar codes

0 vote297 views1 answer
Cv2 get framerete video
Python
0 vote282 views1 answer
Multiplication of matrix in python
Python
0 vote295 views1 answer
Convert ipynb to py
Python
0 vote296 views1 answer
Conda cassandra
Python
0 vote303 views1 answer
Bs4 table examples python
Python
0 vote276 views1 answer
What are the mouseX/mouseY variebles in pycharm
Python
0 vote429 views1 answer
AttributeError: 'QuerySet' object has no attribute django
Python Django
0 vote297 views1 answer
Python die
Python
0 vote302 views1 answer
How to show webcam in opencv
Python
6 votes307 views2 answers
Python type annotations
Python