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]