Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 07 Jan 2010 18:30:01 -0500
From:      Michael Powell <nightrecon@hotmail.com>
To:        freebsd-questions@freebsd.org
Subject:   Re: Possible mysql.sock problem | ERROR 2002 (HY000)
Message-ID:  <hi5qpm$615$1@ger.gmane.org>
References:  <27001411.post@talk.nabble.com> <4B409F3A.80405@infracaninophile.co.uk> <27066296.post@talk.nabble.com>

next in thread | previous in thread | raw e-mail | index | archive | help
jaymax wrote:

> 
> Thanks !!!
> Got it resolved after adding
> mysql_socket="/usr/tmp/mysql.sock" to the rc.conf file
> Removing the /etc/my.cnf file as the aetting were redundant with those
> used in the compilation
> deinstalling and reinstalling both the server and the client
> 
[snip]

The "new" default location for my.cnf as installed by the ports system is 
now /usr/local/etc, although MySQL will still find it if it is in 
mysql_dbdir.
 
MySQL startup will skip it if it has world write permissions on it, more 
specific info is in the docs. I just chmod mine 444 when I'm done with it as 
it is something I don't change once configured. But if you have two of them 
the permissions thingy can be the cause of why it skips over and ignores the 
one you think it should be using.

-Mike





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?hi5qpm$615$1>