From owner-freebsd-questions@FreeBSD.ORG Sun Jun 28 14:17:21 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 C653B1065723 for ; Sun, 28 Jun 2009 14:17:21 +0000 (UTC) (envelope-from freebsd-questions@pp.dyndns.biz) Received: from mtah11.telenor.se (mtah11.telenor.se [62.127.194.4]) by mx1.freebsd.org (Postfix) with ESMTP id 7B7778FC19 for ; Sun, 28 Jun 2009 14:17:21 +0000 (UTC) (envelope-from freebsd-questions@pp.dyndns.biz) Received: from iph2.telenor.se (iph2.telenor.se [195.54.127.133]) by mtah11.telenor.se (Postfix) with ESMTP id 14E9560F78 for ; Sun, 28 Jun 2009 16:17:20 +0200 (CEST) X-SMTPAUTH-B2: X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: Apd9ADsYR0pV4jsLPGdsb2JhbACBUZcjAQEBATeyLIQNBYE3 X-IronPort-AV: E=Sophos;i="4.42,303,1243807200"; d="scan'208";a="23602385" Received: from c-0b3be255.107-1-64736c10.cust.bredbandsbolaget.se (HELO gatekeeper.pp.dyndns.biz) ([85.226.59.11]) by iph2.telenor.se with ESMTP; 28 Jun 2009 16:17:19 +0200 Received: from [192.168.69.67] (phobos [192.168.69.67]) by gatekeeper.pp.dyndns.biz (8.14.3/8.14.3) with ESMTP id n5SEHHtf088342 for ; Sun, 28 Jun 2009 16:17:18 +0200 (CEST) (envelope-from freebsd-questions@pp.dyndns.biz) Message-ID: <4A477B6D.8080608@pp.dyndns.biz> Date: Sun, 28 Jun 2009 16:17:17 +0200 From: =?ISO-8859-1?Q?Morgan_Wesstr=F6m?= User-Agent: Thunderbird 2.0.0.21 (X11/20090430) MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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:17:22 -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)* > > *and when I edit /var/db/mysql/leonidas.MSHOME.err I see this:* > > *090628 14:49:19 mysqld started > 090628 14:49:19 [Warning] Ignoring user change to 'ser=mysql' because the > user was set to 'mysql' e > > 090628 14:49:20 InnoDB: Started; log sequence number 0 43655 > 090628 14:49:20 [ERROR] Can't start server : Bind on unix socket: Permission > denied > 090628 14:49:20 [ERROR] Do you already have another mysqld server running on > socket: /tmp/mysql.soc > 090628 14:49:20 [ERROR] Aborting > > 090628 14:49:20 InnoDB: Starting shutdown... > 090628 14:49:22 InnoDB: Shutdown completed; log sequence number 0 43655 > 090628 14:49:22 [Note] /usr/local/libexec/mysqld: Shutdown complete > > 090628 14:49:22 mysqld ended > > *I have checked /tmp and there is no mysql.sock file. (because I formated > /tmp immagine) > I wouldn't like to loose my database, and I have no idea.... > What I have to do? > > Thanx! :D Don't forget to chmod 1777 /tmp /Morgan