From owner-freebsd-questions@FreeBSD.ORG  Sun Jun 28 13:37:15 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 00C081065670
	for <freebsd-questions@freebsd.org>;
	Sun, 28 Jun 2009 13:37:15 +0000 (UTC)
	(envelope-from atr0x23@gmail.com)
Received: from mail-bw0-f210.google.com (mail-bw0-f210.google.com
	[209.85.218.210])
	by mx1.freebsd.org (Postfix) with ESMTP id 6E1E88FC13
	for <freebsd-questions@freebsd.org>;
	Sun, 28 Jun 2009 13:37:14 +0000 (UTC)
	(envelope-from atr0x23@gmail.com)
Received: by bwz6 with SMTP id 6so350757bwz.43
	for <freebsd-questions@freebsd.org>;
	Sun, 28 Jun 2009 06:37:13 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=QxVVpDGWtWj5NaiqIF2XP6VxD5DeDLrZeO/ckrrkd20=;
	b=Ltdy82mxQaG2qzutLUEcFf0b2nC7Am085BhZwYscFGUHyRrs0iwYD+mik6ixPFUcnb
	Tl8JD9J6Rqva4mfPLJIH8T1hw+3qwm6viUYmzrPfbutBEMyJa9/UPYkPhd5xzbZNVATz
	e042j/xs7UE8pauqA/SdwBd6YzyB6UFxsSLhs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=wmbxh2r0xa5Hc/3ZmCamVPLC+kWBtUM8YoQlve5bVdokqdCII2OtIHEpqheg5DVvqH
	xwSYtqsuQm2z0JfDRxSjGlkfEMMlcOo99tUm2mlIz1OSVF0z08GlDIIoyhUviggUDyeD
	1Iow/rpkQuKWwuUu+mylapaR8V9Uw3tzfZItM=
MIME-Version: 1.0
Received: by 10.223.113.136 with SMTP id a8mr3906715faq.101.1246194735672; 
	Sun, 28 Jun 2009 06:12:15 -0700 (PDT)
Date: Sun, 28 Jun 2009 16:12:15 +0300
Message-ID: <d4a469990906280612lbed863fx45263c3463094ceb@mail.gmail.com>
From: thanos trompoukis <atr0x23@gmail.com>
To: freebsd-questions@freebsd.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Subject: mysql error
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: Sun, 28 Jun 2009 13:37:15 -0000

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