Encrypting MySQL connections
 
I begin to look at encrypting Mysql connection after reading
a sysadmin article relating to stunnel.
 
 
InstallSL
 
./config --prefix=/usr/local --sldir=/usr/local/sl
 
Install stunnel
 
./configure
make
make install
 
stunnel command options used to make it happen
-P arg        specify pid file { dir/ | filename | none }
-c            client mode (remote service uses SSL)
-d [host:]port   daemon mode (host defaults to INADDR_ANY)
-r [host:]port   connect to remote service (host defaults to INADDR_LOOPBACK)
-p pemfile    private key/certificate PEM filename
 
Client Setup
./stunnel -P/tmp/ -c -d 3306 -r mylaptop:3307
 
Server Setup
./stunnel -P/tmp/ -p stunnel.pem -d 3307 -r localhost:3306
 
 
to see that it's working goto
http://trinux.org/pkg/ dload sniffit.tgz
 
./sniffit -i Interactive mode
 
 
from the client machine
mysql -h127.0.0.1
mysql> use mysql
mysql> select * from users