Hi,
Help me please, how to connect to mysql database through SSH. ZeosLib can do SSH -tunnel?
Thanks.
ZeosLib & SSH ?
Moderators: gto, EgonHugeist
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
peshka,
I see you've got your account working
Concerning your SSH-tunnel. In principle there's no difference between using the mysql command line tool over SSH and using zeoslib-powered applications over the same tunnel.
If you get the command line mysql client working over the tunnel, I'm sure zeoslib will not have trouble with it.
Googling gives me some links:
http://www.murdoch-sutherland.com/mysql.html
http://www.whoopis.com/howtos/mysql_ssh_howto.html
http://www.howtoforge.com/secure_mysql_ ... ssh_tunnel
http://www.howtogeek.com/howto/ubuntu/a ... -over-ssh/
Once the tunnel is set up (which can not be done by zeoslib), you can connect using host=localhost and port=<tunneled port>
Mark
BTW: never done it myself, so I can't help with the practical tunnel details.
I see you've got your account working
Concerning your SSH-tunnel. In principle there's no difference between using the mysql command line tool over SSH and using zeoslib-powered applications over the same tunnel.
If you get the command line mysql client working over the tunnel, I'm sure zeoslib will not have trouble with it.
Googling gives me some links:
http://www.murdoch-sutherland.com/mysql.html
http://www.whoopis.com/howtos/mysql_ssh_howto.html
http://www.howtoforge.com/secure_mysql_ ... ssh_tunnel
http://www.howtogeek.com/howto/ubuntu/a ... -over-ssh/
Once the tunnel is set up (which can not be done by zeoslib), you can connect using host=localhost and port=<tunneled port>
Mark
BTW: never done it myself, so I can't help with the practical tunnel details.