SSH Tunnel for Python MySQLdb connection with public key

Question

I am trying to use MySQLdb but I didn't find anywhere how to make connection throught a SSH Tunel using a public key. Anybody can please guide me throught this ?

Thank you very much.

PepperoniPizza · Accepted Answer · 2013-09-06 04:48:41Z

1

As you said, you need first to create a tunnel, so in your shell do:

ssh -i ~/.ssh/keyfile.pem -L 3306:127.0.0.1:22 <hostIP>

and change your Python code to something like the following for connecting:

conn = MySQLdb.connect(host='127.0.0.1', port=3306, user='username', passwd='pass', db='DB')

answered Sep 6, 2013 at 4:48

PepperoniPizza

9,18211 gold badges68 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2741700 Over a year ago

Thanks, I have tried those both : ssh -i C:\\id_dsa -L 3306:127.0.0.1:22 xxx.xxx.xxx.xxx and ssh -i 'C:\\id_dsa' -L 3306:127.0.0.1:22 xxx.xxx.xxx.xxx but i got the error code SyntaxError: invalid syntax. Note that it is normal that my file doesn't have any extension, that's the way it was give it to me.

PepperoniPizza Over a year ago

Oh I didn't think you were on Windows, let me search the ssh command for that.

JohnDotOwl Over a year ago

@PepperoniPizza I'm on windows too, how do i SSH , i have putty running and can connect to phpmyadmin from browser already

Collectives™ on Stack Overflow

SSH Tunnel for Python MySQLdb connection with public key

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related