From owner-freebsd-database@FreeBSD.ORG  Mon Mar 27 06:13:23 2006
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: 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 AD3E716A420
	for <freebsd-database@freebsd.org>;
	Mon, 27 Mar 2006 06:13:23 +0000 (UTC)
	(envelope-from peptide1@gmail.com)
Received: from pproxy.gmail.com (pproxy.gmail.com [64.233.166.177])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3D99243D4C
	for <freebsd-database@freebsd.org>;
	Mon, 27 Mar 2006 06:13:23 +0000 (GMT)
	(envelope-from peptide1@gmail.com)
Received: by pproxy.gmail.com with SMTP id m51so1087195pye
	for <freebsd-database@freebsd.org>;
	Sun, 26 Mar 2006 22:13:22 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=h70jN6JdInYBC4jnHoEM+tegPoidwWgE2j8ZAfbo83w5VJqFw3JPRRUvOPda44mXTgzZXSWIgTRHtPFaHUJ4VGnspaGYEFpxSlB+rmEb9wuIIxo6YOBnfzwT9bMzSHUbLA1m7oWi62+RQFywuMXGWEJ2g8Ydbc5xxGhFULcFruo=
Received: by 10.65.228.1 with SMTP id f1mr2115894qbr;
	Sun, 26 Mar 2006 22:13:22 -0800 (PST)
Received: by 10.65.147.9 with HTTP; Sun, 26 Mar 2006 22:13:22 -0800 (PST)
Message-ID: <4b4e1af10603262213g11b0943g1455e9ddb2a4e095@mail.gmail.com>
Date: Sun, 26 Mar 2006 22:13:22 -0800
From: "peptide one" <peptide1@gmail.com>
To: freebsd-database@freebsd.org
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Subject: mysql can't connect 2002 & socket error
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
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: Mon, 27 Mar 2006 06:13:23 -0000

Hello all,

I've been scanning these mail lists for a solution and have tried many
things, but am still not able to start the MySQL 5.0 database on my FreeBSD
5.4 server. I've been working on this for two days and have never had so
many problems getting a database to start.

The first thing I did after installation was copy the /support-files/my-
medium.cnf
to
/etc/my.cnf
and  enter the appropriate information.
I also created a "dummy" /tmp/mysql.sock file and configured permissions.
I try starting the server as user "mysql" and it fails. Trying to su or
login as mysql fails with a 'miscofiguration' error.

All this has happened after I've deinstalled and cleaned two previous
installations.

This is getting to be much more work than it should be.

Can anyone help? It would certainly be appreciated.

Thanks in advance.