From owner-freebsd-database Thu Aug 5 4:45:59 1999 Delivered-To: freebsd-database@freebsd.org Received: from pawn.primelocation.net (pawn.primelocation.net [205.161.238.235]) by hub.freebsd.org (Postfix) with ESMTP id 1E833154C3 for ; Thu, 5 Aug 1999 04:45:57 -0700 (PDT) (envelope-from jedgar@fxp.org) Received: by pawn.primelocation.net (Postfix, from userid 1003) id EC8D8F818; Thu, 5 Aug 1999 07:45:37 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by pawn.primelocation.net (Postfix) with ESMTP id DEC0E9B15; Thu, 5 Aug 1999 07:45:37 -0400 (EDT) Date: Thu, 5 Aug 1999 07:45:37 -0400 (EDT) From: "Chris D. Faulhaber" X-Sender: jedgar@pawn.primelocation.net To: "Brian V. McGroarty" Cc: freebsd-database@freebsd.org Subject: Re: mysql 322 - no socket file In-Reply-To: <37A912AC.361FAAE9@pobox.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk 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 | 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