I am trying to connect to a remote MySQL Database over SSH. I am using paramiko
and SQLAlchemy. I assume that my sqlalchemy engine is not going through the SSH
tunnel. Here is what i have so far. Not sure where to go from here though.
import paramiko
from sqlalchemy import create_engine
ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect('host.com', port=port, username='usr', password='pass')
engine = create_engine('mysql+mysqldb://[email protected]:3306/db')
I am getting this error:
--
https://mail.python.org/mailman/listinfo/python-list