Just to toss something else in here. A lot of times you have a server that you can connect to by ssh, but because of firewalls, can't access mysql through. If you can, however, connect to the database through ssh, you can do port forwarding. In *nix systems it should be something like this:

ssh -L 3306:server.com:3306 -N -f [EMAIL PROTECTED]

This will forward requests from port 3306 locally to port 3306 on server.com. If you're on windows, you can also do port forwarding through putty:

http://www.cs.uu.nl/technical/services/ssh/putty/puttyfw.html

This becomes pretty easy when you get the hang of it.  You can also do like:

ssh -L 3000:server.com:3306 -N -f [EMAIL PROTECTED]

if you're, say, running a local mysql instance. As a reminder connections will have to occur to localhost, not the server. Hope this helps.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to