/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

3 votes194 views1 answer
Django user group check
Python Django
0 vote143 views1 answer
Get the mean of all not nan values
Python
0 vote132 views1 answer
Email python library get all messages
Python
9 votes130 views1 answer
'python3' is not recognized as an internal or external command,
Python
0 vote195 views1 answer
Python glob subdirectories
Python
0 vote140 views1 answer
Py variable space padding
Python
0 vote136 views1 answer
Banner grabber api
Python
0 vote131 views1 answer
How do i activate python on windows
Python
1 vote127 views1 answer
Get csrf_token value in django template
Python
0 vote138 views1 answer
How to import flask restful using pip
Python