Posted by Andy Hassall on 09/12/07 20:26

On Wed, 12 Sep 2007 20:00:33 -0000, mtuller <mituller@gmail.com> wrote:

>I would like to encrypt data passed between my web server and the
>database server.

How about:

http://www.php.net/manual/en/function.mysql-connect.php

client_flags, MYSQL_CLIENT_SSL

>I have looked all over, but don't see any information
>on how to connect to mysql via ssh

Well, you could set up an SSH tunnel for the relevant port (3306, using the -D
flag, or use stunnel or something else like that) and run the standard
(unencrypted) MySQL protocol through the encrypted tunnel, but that's another
step on top of just using the built-in SSL support (assuming a non-ancient
version of MySQL, and that it works as advertised anyway).

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]