Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 5 Aug 1999 07:45:37 -0400 (EDT)
From:      "Chris D. Faulhaber" <jedgar@fxp.org>
To:        "Brian V. McGroarty" <bvmcg@pobox.com>
Cc:        freebsd-database@freebsd.org
Subject:   Re: mysql 322 - no socket file
Message-ID:  <Pine.BSF.4.10.9908050741490.72854-100000@pawn.primelocation.net>
In-Reply-To: <37A912AC.361FAAE9@pobox.com>

next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, 4 Aug 1999, Brian V. McGroarty wrote:

> #mysqladmin status
> mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)'
> Check that mysqld is running and that the socket: '/tmp/mysql.sock'
> exists!
> 

You built MySQL using pthreads instead of native threads.  If you read the
documentation for MySQL (Section 4.9):

     * MIT-pthreads doesn't support the AF_UNIX protocol used to
       implement Unix sockets. This means that if you compile using
       MIT-pthreads, all connections must be made using TCP/IP (which is
       a little slower). If you find after building MySQL that you cannot
       connect to the local server, it may be that your client is
       attempting to connect to localhost using a Unix socket as the
       default. Try making a TCP/IP connection with mysql by using a host
       option (-h or --host) to specify the local host name explicitly.

Either compile w/native threads or use the -h flag.

-----
Chris D. Faulhaber <jedgar@fxp.org>  |  All the true gurus I've met never
System/Network Administrator,        |  claimed they were one, and always
Reality Check Information, Inc.      |  pointed to someone better.




To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.10.9908050741490.72854-100000>