Mysqldb Through Proxy

I'm using the above mentioned Python lib to connect to a MySQL server. So far I've worked locally and all worked fine, until i realized I'll have to use my program in a network whe

Solution 1:

I use ssh tunneling for that kind of issues. For example I am developing an application that connects to an oracle db.

In my code I write to connect to localhost and then from a shell I do:

ssh -L1521:localhost:1521user@server.com

If you are in windows you can use PuTTY

Solution 2:

there are a lot of different possibilities here. the only way you're going to get a definitive answer is to talk to the person that runs the proxy.

if this is a web app and the web server and the database serve are both on the other side of a proxy, then you won't need to connect to the mysql server at all since the web app will do it for you.

Solution 3:

Do you have to do anything special to connect through a proxy?

I would guess you just supply the correct parameters to the connect function. From the documentation, it looks as if you can specify the host name and port number with an arguments to connect.

Like this:

connection = connect(host="dbserver.somewhere.com", port=nnnn)
# etc..