Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 28 Jun 2009 16:17:17 +0200
From:      =?ISO-8859-1?Q?Morgan_Wesstr=F6m?= <freebsd-questions@pp.dyndns.biz>
To:        freebsd-questions@freebsd.org
Subject:   Re: mysql error
Message-ID:  <4A477B6D.8080608@pp.dyndns.biz>
In-Reply-To: <d4a469990906280612lbed863fx45263c3463094ceb@mail.gmail.com>
References:  <d4a469990906280612lbed863fx45263c3463094ceb@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help


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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4A477B6D.8080608>