[ubuntu-uk] mySQL over ssh tunnel?

[Lucy]

On 06/12/2007, Michael Holloway <michael at thedarkwinter.com> wrote:
> Hi Guys
>
> I want to ask you opinion on this...
>
> I want to have a mysql asynchronous replication slave connected over the
> internet (through IP validating firewalls, not VPN).
>
> Is it secure to just use a normal mysql connection? Or is the data
> un-encrypted, and if so, how easy to sniff/intercept?
>
> I'm guessing that using an SSH tunnel (something i've never done before)
> is the best way to do this??
>
> Any opinions/pointers?

You can setup MySQL to use a secure connection without having to setup
your own SSH tunnel. See:
http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html