From owner-freebsd-database@FreeBSD.ORG Sun Feb 18 18:29:24 2007 Return-Path: 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 105C516A402 for ; Sun, 18 Feb 2007 18:29:24 +0000 (UTC) (envelope-from x_element108@btinternet.com) Received: from smtp814.mail.ukl.yahoo.com (smtp814.mail.ukl.yahoo.com [217.12.12.204]) by mx1.freebsd.org (Postfix) with SMTP id 69D3F13C471 for ; Sun, 18 Feb 2007 18:29:23 +0000 (UTC) (envelope-from x_element108@btinternet.com) Received: (qmail 63586 invoked from network); 18 Feb 2007 18:02:42 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=btinternet.com; h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:X-Enigmail-Version:Content-Type:Content-Transfer-Encoding; b=lVfoqbaCHspvdJ/59ySR3Xlt4zQfXwYZGn8igm8QbHHMjqt5lQjrn2/9ab0hFp3aqeZ4jZ1osD4NbQ8HgOd0TO9kdK04is1BIJZ0iWggiWSJC2mafppduAvMd/HjNOOGAH1mCVNc/jelvngOfalCO5lHE1Q370uViqeKTEvAP1g= ; Received: from unknown (HELO ?192.168.1.67?) (x_element108@btinternet.com@86.133.112.228 with plain) by smtp814.mail.ukl.yahoo.com with SMTP; 18 Feb 2007 18:02:42 -0000 X-YMail-OSG: 7MjjEyQVM1nQIhgPL_OPJal4TET3AMJeGa5suZ63yKhfpqBTt_KckyKCyROHo_4gkkDF8rl1fyHS0aCKZoi5JOjfGg6CAqCEz4i9uIuIF0dOPkhIjD0SD42Bd39a_yDoagyAQpT5nWQ- Message-ID: <45D894A6.7010209@btinternet.com> Date: Sun, 18 Feb 2007 18:02:14 +0000 From: "Rajen Jani (BT Yahoo! Broadband)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: freebsd-database@freebsd.org X-Enigmail-Version: 0.92.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Subject: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 18 Feb 2007 18:29:24 -0000 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. Regards, Rajen From owner-freebsd-database@FreeBSD.ORG Sun Feb 18 22:19:21 2007 Return-Path: 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 ; 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 ; 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)" 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 From owner-freebsd-database@FreeBSD.ORG Mon Feb 19 11:20:22 2007 Return-Path: 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 0DDCF16A406 for ; Mon, 19 Feb 2007 11:20:22 +0000 (UTC) (envelope-from gpaharenko@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by mx1.freebsd.org (Postfix) with ESMTP id 29AE013C503 for ; Mon, 19 Feb 2007 11:20:19 +0000 (UTC) (envelope-from gpaharenko@gmail.com) Received: by nf-out-0910.google.com with SMTP id m19so2389271nfc for ; Mon, 19 Feb 2007 03:20:08 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:from; b=CDaICbzByq3jjgdeKWMKhDD7Bd8IwooZ9mrju7NZmReWx4AYgve7FN1CQnXgyGgL2qiSfKRwrFldx4QRRR9y7A0hjIuM6z+RNa7FT02taMmSpZaE3664ZM9b4IRQ95SfZwpp8DLAgi8MPXLMNVl7vGwZjikCd/vQxjD+F6GfdKM= Received: by 10.82.160.2 with SMTP id i2mr10581760bue.1171882534840; Mon, 19 Feb 2007 02:55:34 -0800 (PST) Received: from ?192.168.1.7? ( [212.9.255.254]) by mx.google.com with ESMTP id b36sm8259737ika.2007.02.19.02.55.33; Mon, 19 Feb 2007 02:55:34 -0800 (PST) Message-ID: <45D98223.7020204@mail.ru> Date: Mon, 19 Feb 2007 12:55:31 +0200 User-Agent: Thunderbird 1.5.0.8 (X11/20061107) MIME-Version: 1.0 To: "Rajen Jani (BT Yahoo! Broadband)" References: <45D894A6.7010209@btinternet.com> In-Reply-To: <45D894A6.7010209@btinternet.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit From: Gleb Paharenko 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 19 Feb 2007 11:20:22 -0000 Hi! Have a look here: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html Rajen Jani (BT Yahoo! Broadband) пишет: > 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. > > Regards, > > > Rajen > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org" > -- Gleb Paharenko gleban@mail.ru