Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 28 Jun 2009 17:19:14 +0300
From:      Manolis Kiagias <sonicy@otenet.gr>
To:        thanos trompoukis <atr0x23@gmail.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: mysql error
Message-ID:  <4A477BE2.1040404@otenet.gr>
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)*
>
>   

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



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