From owner-freebsd-questions@FreeBSD.ORG  Sat May 20 18:26:58 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 85A0C16A423
	for <freebsd-questions@freebsd.org>;
	Sat, 20 May 2006 18:26:58 +0000 (UTC) (envelope-from kdk@daleco.biz)
Received: from ezekiel.daleco.biz (southernuniform.com [66.76.92.18])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 218A843D46
	for <freebsd-questions@freebsd.org>;
	Sat, 20 May 2006 18:26:58 +0000 (GMT) (envelope-from kdk@daleco.biz)
Received: from [192.168.2.2] ([69.27.149.254])
	by ezekiel.daleco.biz (8.13.4/8.13.1) with ESMTP id k4KIQt6R049564;
	Sat, 20 May 2006 13:26:56 -0500 (CDT) (envelope-from kdk@daleco.biz)
Message-ID: <446F5F6A.7040101@daleco.biz>
Date: Sat, 20 May 2006 13:26:50 -0500
From: Kevin Kinsey <kdk@daleco.biz>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US;
	rv:1.8.0.2) Gecko/20060509 SeaMonkey/1.0.1
MIME-Version: 1.0
To: Peter Michaux <petermichaux@gmail.com>
References: <3cbaf1c80605200857t4043cc4r519088dad9ccc008@mail.gmail.com>
In-Reply-To: <3cbaf1c80605200857t4043cc4r519088dad9ccc008@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-questions@freebsd.org
Subject: Re: installing MySQL with FreeBSD pkg_add
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: Sat, 20 May 2006 18:26:58 -0000

Peter Michaux wrote:

> # mysql -uroot
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> 'tmp/mysql.sock' (2)
> 
> What to do?
> 

The server isn't running.  Start it, and this message
will go away.

If the port/package is correctly installed, then

$ /usr/local/etc/rc.d/mysql-server.sh start

as root should do the trick.

To have mysql-server start automagically, add:

mysql_enable="YES"

to the file /etc/rc.conf

BTW, shouldn't there be a space between the "-u"
and the "root" ?  Probably just a c-n-p error.

KDK

-- 
We are all in the gutter, but some of us are looking at the stars.
		-- Oscar Wilde