root@trax:/etc/rc.d# cat /etc/my.cnf
[client]port=3307
socket=/tmp/mysql.sock2
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = mysql
password = mysql
[mysqld2]
socket = /tmp/mysql.sock2
port = 3307
pid-file = /usr/local/mysql/var2/hostname.pid2
datadir = /usr/local/mysql/var2
language = /usr/local/share/mysql/english
user = mysql
mkdir /usr/local/mysql/var2
cd /usr/local/mysql/
chown mysql.mysql var2
cd /usr
mysql_install_db --user=mysql --datadir=local/mysql/var2 --basedir=/usr
if needed copy mysqld.server.multi to /etc/rc.d
/etc/rc.d/mysql_multi start N
mysqladmin -uroot password --socket=/tmp/mysql.sock --port=PORT
mysql -uroot -p --socket=/tmp/mysql.sock --port=PORT
and allow root access if needed
