Secure MySQL connections

[hugheba]

How would I go about securing my transmissions to and from my MySQL database?

Can I tunnel port 3306 over SSH? How?

I see the SSL option on some apps. Does Mac os x support that?

I just want to make sure the transmissions to and from my database are secure/encrypted...

Any suggestions...?

Thanks in advance.

 

[blb]

To forward a local connection on port 3306 to a remote server through ssh, you would run

ssh -L 3306:remote:3306 user@remote

This will cause localhost:3306 to be tunneled through ssh to remote's 3306.

As far as MySQL and SSL, I believe that is a compile-time option; there's some info at mysql.org