From owner-freebsd-database@FreeBSD.ORG  Fri May 14 10:49:30 2004
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 0A12316A4CE
	for <freebsd-database@freebsd.org>;
	Fri, 14 May 2004 10:49:30 -0700 (PDT)
Received: from mail.day-light.net (day-light.net [64.37.72.2])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 8DEC643D4C
	for <freebsd-database@freebsd.org>;
	Fri, 14 May 2004 10:49:29 -0700 (PDT)
	(envelope-from john@day-light.com)
Received: from w1 (gabriel.day-light.net [69.27.46.22])
	by mail.day-light.net (Postfix) with SMTP
	id A94DA3529B; Fri, 14 May 2004 12:49:28 -0500 (CDT)
From: "John Brooks" <john@day-light.com>
To: <phil@rootnet.ca>, <freebsd-database@freebsd.org>
Date: Fri, 14 May 2004 12:49:29 -0500
Message-ID: <NHBBKEEMKJDINKDJBJHGCECCNNAC.john@day-light.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Importance: Normal
In-Reply-To: <20040514172738.XMB11251.tomts36-srv.bellnexxia.net@rnsd>
Subject: RE: Mysql: ERROR 2002: Can't connect to local MySQL server
	throughsocket '/tmp/mysql.sock'
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: john@day-light.com
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 14 May 2004 17:49:30 -0000

seems like your problem is that mysqld will not start, in
order to start it must be able to read the files that make
up your databases. the directories that hold these files 
can only be read by the user 'mysql' (look at the directory
permissions). mysql uid is normally '88'. you may have other
problems also, but until you fix this they cannot be addressed

hint:  look at the start up script in /usr/local/etc/rc.d
       to see how to start the daemon as the user 'mysql',
       (file name should be something like 'mysql-server.sh')

--
John Brooks
john@day-light.com 

... 
 kernel: pid 27201 (mysqld), uid 10**: exited on signal 6
 
 (which is a sigabort)
...