Has anyone on this list ever been successful in running two MySQL servers at one? I'm assuming they have ;-) I am having some issues and am hoping for some help or pointers to help.
When I try to run my second server I get this error message in the log:
031204 11:35:01 mysqld started 031204 11:35:01 Can't start server : Bind on unix socket: Permission denied 031204 11:35:01 Do you already have another mysqld server running on socket: /data/appenv/mysql/mys ql.sock ? 031204 11:35:01 Aborting
031204 11:35:01 /data/appenv/mysql/bin/mysqld: Shutdown Complete
031204 11:35:01 mysqld ended
But I don't have another server running on that socket; it's the one I'm trying to start. I do have one running at /data/mysql/mysql.sock though.
This is my command to start the second server:
sudo /data/appenv/mysql/bin/safe_mysqld --defaults-file=/data/appenv/mysql/data/my.cnf --user=mysql &
This is the contents of my.cnf I'm using for the second server:
[client] port=3307 socket=/data/appenv/mysql/mysql.sock
[mysqld] port=3307 datadir=/data/appenv/mysql/data socket=/data/appenv/mysql/mysql.sock
[mysql.server] user=mysql basedir=/data/appenv/mysql
[safe_mysqld] err-log=/data/appenv/mysql/logs/mysqld.log pid-file=/var/mysqld.pid
What do you think the issue is?
Jon
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]