/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

1 vote263 views2 answers
Nn.dropout
Python
9 votes268 views2 answers
Python get image dimensions
Python
1 vote236 views1 answer
Convert to lowercase command python
Python
10 votes266 views1 answer
Main function python\
Python
0 vote294 views1 answer
Exit() function
Python
-1 vote268 views2 answers
Opencv python convert rgb to hsv
Python
0 vote271 views1 answer
Typecasting python
Python
0 vote256 views1 answer
Como usar o Self no python
Python
0 vote294 views1 answer
Sklearn import tree
Python
3 votes271 views3 answers
Close a file python
Python