From owner-freebsd-database@FreeBSD.ORG  Sun Feb 18 22:19:21 2007
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 [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 0D16D16A504
	for <freebsd-database@freebsd.org>;
	Sun, 18 Feb 2007 22:19:21 +0000 (UTC)
	(envelope-from 000.fbsd@quip.cz)
Received: from home.quip.cz (grimm.quip.cz [213.220.192.218])
	by mx1.freebsd.org (Postfix) with ESMTP id B840D13C4A3
	for <freebsd-database@freebsd.org>;
	Sun, 18 Feb 2007 22:19:20 +0000 (UTC)
	(envelope-from 000.fbsd@quip.cz)
Received: from [192.168.1.2] (qwork.quip.test [192.168.1.2])
	by home.quip.cz (Postfix) with ESMTP id C066862ED;
	Sun, 18 Feb 2007 22:49:55 +0100 (CET)
Message-ID: <45D8CA03.5020808@quip.cz>
Date: Sun, 18 Feb 2007 22:49:55 +0100
From: Miroslav Lachman <000.fbsd@quip.cz>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.7.12) Gecko/20050915
X-Accept-Language: cz, cs, en, en-us
MIME-Version: 1.0
To: "Rajen Jani (BT Yahoo! Broadband)" <x_element108@btinternet.com>
References: <45D894A6.7010209@btinternet.com>
In-Reply-To: <45D894A6.7010209@btinternet.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-database@freebsd.org
Subject: Re: Error 2002 (HY000) Can't connect to local MySQL server through
 socket '/tmp/mysql.sock' (2)
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: Sun, 18 Feb 2007 22:19:21 -0000

Rajen Jani (BT Yahoo! Broadband) wrote:
> Hi  everyone,
> 
>           I have installed mySQL server 5.0.27 from the ports directory.
> Everytime I connect to it using
> "mysql -h localhost -u rajen -p" I get the above error. I have no idea
> as to how I can resolve this
> problem. I have tried telneting localhost and it says that the
> connection is refused. Please suggest
> how I can get around this, Thanks.

Is MySQL daemon runnig? What is output of command:
ps -auxwww | grep mysqld

and output of

ls -al /tmp/mysql.sock

Can you connect to MySQL from other software, or by mysql -h 127.0.0.1 
-u rajen -p ?

Miroslav Lachman