From owner-freebsd-database Wed Aug 4 21:28:27 1999 Delivered-To: freebsd-database@freebsd.org Received: from elmls02.ce.mediaone.net (elmls02.ce.mediaone.net [24.131.128.27]) by hub.freebsd.org (Postfix) with ESMTP id 2190014CF3 for ; Wed, 4 Aug 1999 21:28:14 -0700 (PDT) (envelope-from bvmcg@pobox.com) Received: from pobox.com (rm02-24-29-199-43.ce.mediaone.net [24.29.199.43]) by elmls02.ce.mediaone.net (8.8.7/8.8.7) with ESMTP id XAA23116 for ; Wed, 4 Aug 1999 23:27:44 -0500 (CDT) Message-ID: <37A912AC.361FAAE9@pobox.com> Date: Wed, 04 Aug 1999 23:27:24 -0500 From: "Brian V. McGroarty" X-Mailer: Mozilla 4.61 [en] (X11; U; FreeBSD 4.0-CURRENT i386) X-Accept-Language: en MIME-Version: 1.0 To: freebsd-database@freebsd.org Subject: mysql 322 - no socket file Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Am I skipping a step? I'm trying to install and run mysql #cd /usr/ports/databases/mysql322-server #make install #mysql_install_db #safe_mysqld & #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! #ls -la /var |grep -in sock {nothing} #ps ax |grep -in mysql 59: 7971 p2 I 0:00.01 /bin/sh /usr/local/bin/safe_mysqld 60: 7980 p2 I 0:00.03 /usr/local/libexec/mysqld --basedir=/usr/local --data #cat /usr/var/db/mysql/milkymoo.newtoy.com.err Status information: Current locks: key_cache status: blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key: 0 read_next: 0 read_rnd 0 read_first: 0 write: 0 delete 0 update: 0 Table status: Opened tables: 0 Open tables: 0 Open files: 0 Open streams: 0 mysqld started on Wed Aug 4 22:56:07 CDT 1999 /usr/local/libexec/mysqld: ready for connections To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message 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