mysql error

Manolis Kiagias sonicy at
Sun Jun 28 14:19:18 UTC 2009

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 at 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

More information about the freebsd-questions mailing list