/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

4 votes105 views3 answers
Python fibbonacci
Python
1 vote124 views1 answer
Django populate choice field from database
Python Django
1 vote136 views1 answer
Correr servidor django
Python
0 vote100 views1 answer
Make image to string to use in tkinter
Python
0 vote106 views1 answer
Install easygui
Python
0 vote96 views1 answer
Change xlabel python
Python
0 vote96 views1 answer
Win32api.mouse_event python
Python
7 votes100 views1 answer
PIL discord
Python
1 vote116 views3 answers
Sort a string in python
Python
0 vote99 views1 answer
Como poner estado a un bot en discord
Python