/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 vote535 views1 answer
Warning message: In scan(file = file, what = what, sep = sep, quote = quote, dec = dec, : EOF within quoted string
Python
9 votes199 views2 answers
Tar unpack to folder
Python
2 votes195 views3 answers
If string contains list of letters python
Python
3 votes186 views1 answer
Update all modules python in cmd
Python
0 vote234 views1 answer
What is NoReverseMatch in django?
Python
0 vote212 views1 answer
Python http handler iis
Python
1 vote246 views2 answers
Python remove dict key/values
Python
0 vote207 views1 answer
Django populate form from database
Python
0 vote224 views1 answer
Django.com
Python Django
13 votes203 views4 answers
How to count number of unique values in a column python
Python