Òàðàñ wrote:
Hi! I need two MySQL servers run simultaneously. But when I try to run server I 
have

 ERROR 2002 (HY000): Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (2)

Does this happen when you try to start the first instance, or starting the second instance when you already have one started.

If the latter is the case, you are going to have to tell the second instance to use a different socket file.

# touch /tmp/mysql.sock2
# chmod mysql_user:mysql_group /tmp/mysql.sock2

....and then, I believe if you add this to your /etc/my.cnf file:

[mysqld]
socket=/tmp/mysql.sock2

This should start at least one of your instances on the new socket, leaving the other one alone.

Note: I have not tested the above, its off the top of my head. Be worth Googling for verification.

Steve
_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to