From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.43) id 1EAaEW-0007UD-7Y for garchives@archives.gentoo.org; Wed, 31 Aug 2005 21:35:00 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.4/8.13.4) with SMTP id j7VLVkWF002600; Wed, 31 Aug 2005 21:31:46 GMT Received: from bullet.espersunited.com (24-117-226-93.cpe.cableone.net [24.117.226.93]) by robin.gentoo.org (8.13.4/8.13.4) with ESMTP id j7VLRRnx017074 for ; Wed, 31 Aug 2005 21:27:28 GMT Received: from baby.espersunited.com (baby.espersunited.com [192.168.1.3]) by bullet.espersunited.com (8.13.4/8.13.3) with ESMTP id j7VLSsiF029195 for ; Wed, 31 Aug 2005 16:28:55 -0500 Subject: Re: [gentoo-user] Trouble with mysql From: Michael Sullivan To: gentoo-user@lists.gentoo.org In-Reply-To: <1125523247.12457.63.camel@localhost> References: <1125521529.11373.9.camel@baby.espersunited.com> <1125523247.12457.63.camel@localhost> Content-Type: text/plain Date: Wed, 31 Aug 2005 16:29:46 -0500 Message-Id: <1125523786.11368.13.camel@baby.espersunited.com> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 Content-Transfer-Encoding: 7bit X-Archives-Salt: 21000fe1-78d0-4848-b4c3-a844159c5b42 X-Archives-Hash: f62856bb5d7b55128a5120138a86d194 On Wed, 2005-08-31 at 17:20 -0400, Eric Crossman wrote: > On Wed, 2005-08-31 at 15:52 -0500, Michael Sullivan wrote: > > I am having trouble with /etc/init.d/mysql. I rebooted my system, and > > when it finished rebooting I tried to connect to the mysql daemon and > > failed. I looked in /var/log/mysql: There was a file there called > > mysql.err. The contents were: > > > > 050831 15:47:29 mysqld started > > 050831 15:47:30 Can't start server: Bind on TCP/IP port: Address already > > in use > > 050831 15:47:30 Do you already have another mysqld server running on > > port: 3306 ? > > 050831 15:47:30 Aborting > > > > 050831 15:47:30 /usr/sbin/mysqld: Shutdown Complete > > > > 050831 15:47:30 mysqld ended > > > > > > I tried netstat | grep '3306': > > > > bullet mysql # netstat | grep '3306' > > bullet mysql # > > > > The output was blank, so I assume that port 3306 is NOT in use. Any > > ideas? > > > > Try netstat -an | grep 3306. The "-n" option forces netstat to show port > numbers and not translate them to familiar names. The "-p" option is > also useful to determine what program has opened the port. > > Eric I ran netstat with -an grepping for port 3306. It found it: bullet ~ # netstat -an | grep 3306 tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN so I grepp'd netstat for mysql: bullet ~ # netstat | grep 'mysql' unix 3 [ ] STREAM CONNECTING 0 /var/run/mysqld/mysqld.sock It was running, so I tried using the mysql client: bullet ~ # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) bullet ~ # I don't understand this... -- gentoo-user@gentoo.org mailing list