#PYTHON MYSQL SSH TUNNEL INSTALL#

Remote_bind_address=(sql_host, sql_port)) as tunnel:ĭata = pd. Works like charm! import nnectorĬonfig.read('c:/work/tmf/data_model/tools/config.ini') Ssh_pkey='/home/userName/.ssh/id_ed25519',Ĭnx = (user='sql_username',Ĭursor.execute('SELECT * FROM db_name.tableName ')īest practice is to parameterize the connection variables.

#PYTHON MYSQL SSH TUNNEL INSTALL#

With sshtunnel.SSHTunnelForwarder(ssh_address_or_host='ssh_host', the mysql command locally (not from the ssh session) to try to connect to it if that works, run your python script (without the ssh tunnelling stuff) to. sshtunnel is on PyPI, so simply run: pip install sshtunnel or easyinstall sshtunnel or conda install -c conda-forge sshtunnel to have it installed in your environment. In case of an error on SQL server side, you do not receive an error message from SQL-server. If you use nnector from Oracle you must use a constructionĬnx = (.Īlso, your SQL statement must be ideal. You may only write the path to the private key file: ssh_pkey='/home/userName/.ssh/id_ed25519' (documentation is here: ).

Python mysql ssh tunnel