From owner-freebsd-questions@FreeBSD.ORG  Thu Jan  7 23:30:26 2010
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 6E62D1065697
	for <freebsd-questions@freebsd.org>;
	Thu,  7 Jan 2010 23:30:26 +0000 (UTC)
	(envelope-from freebsd-questions@m.gmane.org)
Received: from lo.gmane.org (lo.gmane.org [80.91.229.12])
	by mx1.freebsd.org (Postfix) with ESMTP id 2B0128FC25
	for <freebsd-questions@freebsd.org>;
	Thu,  7 Jan 2010 23:30:25 +0000 (UTC)
Received: from list by lo.gmane.org with local (Exim 4.50) id 1NT1o7-000417-2a
	for freebsd-questions@freebsd.org; Fri, 08 Jan 2010 00:30:23 +0100
Received: from pool-70-21-4-230.res.east.verizon.net ([70.21.4.230])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <freebsd-questions@freebsd.org>; Fri, 08 Jan 2010 00:30:22 +0100
Received: from nightrecon by pool-70-21-4-230.res.east.verizon.net with local
	(Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <freebsd-questions@freebsd.org>; Fri, 08 Jan 2010 00:30:22 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: freebsd-questions@freebsd.org
From: Michael Powell <nightrecon@hotmail.com>
Followup-To: gmane.os.freebsd.questions
Date: Thu, 07 Jan 2010 18:30:01 -0500
Lines: 24
Message-ID: <hi5qpm$615$1@ger.gmane.org>
References: <27001411.post@talk.nabble.com>
	<4B409F3A.80405@infracaninophile.co.uk>
	<27066296.post@talk.nabble.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7Bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: pool-70-21-4-230.res.east.verizon.net
Sender: news <news@ger.gmane.org>
Subject: Re: Possible mysql.sock problem | ERROR 2002 (HY000)
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 07 Jan 2010 23:30:26 -0000

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