PHWinfo - Afficher un message

12/09/2007, 22h26

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

12/09/2007, 22h26	#3
Andy Hassall Messages: n/a Hébergeur:	Re: php connect to mysql via ssh 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