From owner-freebsd-questions@FreeBSD.ORG Sun Jun 28 14:19:17 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9B0BF10656C3 for ; Sun, 28 Jun 2009 14:19:17 +0000 (UTC) (envelope-from sonicy@otenet.gr) Received: from aiolos.otenet.gr (aiolos.otenet.gr [83.235.67.30]) by mx1.freebsd.org (Postfix) with ESMTP id 034EE8FC18 for ; Sun, 28 Jun 2009 14:19:16 +0000 (UTC) (envelope-from sonicy@otenet.gr) Received: from atomic.dyndns.org (athedsl-4487283.home.otenet.gr [94.71.68.123]) by aiolos.otenet.gr (8.13.8/8.13.8/Debian-3) with ESMTP id n5SEJE5Y027319; Sun, 28 Jun 2009 17:19:14 +0300 Message-ID: <4A477BE2.1040404@otenet.gr> Date: Sun, 28 Jun 2009 17:19:14 +0300 From: Manolis Kiagias User-Agent: Thunderbird 2.0.0.21 (X11/20090414) MIME-Version: 1.0 To: thanos trompoukis References: In-Reply-To: X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: mysql error X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 28 Jun 2009 14:19:18 -0000 thanos trompoukis wrote: > Hi all, I am new with FreeBSD and I have a problem with mysql. > > I have 6.2Release i386 > I am running mysql 5.0.27 and It worked perfectly until the time that I > formated /tmp (for some other reason) > and now when I am trying to connect on mysql *I get this:* > > *[root@leonidas:/]$ mysql > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/tmp/mysql.sock2' (38)* > > Ha, I know this, it happened to me once I messed with tmp, and its pretty simple: /tmp has the sticky bit "set". If you forget it, some programs fail mysteriously. So just do a chown -R root:wheel /tmp (just to be safe) and chmod -R 1777 /tmp and all will be fine