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.54) id 1F5aYx-0007ig-Vd for garchives@archives.gentoo.org; Sun, 05 Feb 2006 03:27:44 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id k153QY93025963; Sun, 5 Feb 2006 03:26:34 GMT Received: from mxfep01.bredband.com (mxfep01.bredband.com [195.54.107.70]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id k153Mdu9025079 for ; Sun, 5 Feb 2006 03:22:39 GMT Received: from Larissa ([213.114.157.65] [213.114.157.65]) by mxfep01.bredband.com with SMTP id <20060205032250.WRQK12400.mxfep01.bredband.com@Larissa> for ; Sun, 5 Feb 2006 04:22:50 +0100 Message-ID: <000e01c62a03$69d2f7e0$419d72d5@Larissa> From: "Fredrik Lundgren" To: References: <000701c629e7$d9b09390$419d72d5@Larissa> <000801c629f4$c4dcedd0$419d72d5@Larissa> <5FDCB6D7-FB7F-4FD0-85BF-E6933AAA59D0@jolet.net> Subject: Re: [gentoo-user]Solved ... Can't connect to local MySQL server ... Date: Sun, 5 Feb 2006 04:22:35 +0100 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 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Archives-Salt: b903beb3-ab25-4107-a96e-34ea3cea1da2 X-Archives-Hash: 2e7c855f1a574674dae88071f01e7b3f Dear list, It appears as if mysql 5.0.18-r30 sets up: datadir = /var/lib/mysql-500 while my.cnf was from earlier version (I thought I deleted it with etc-update) indicating: datadir =/var/lib/mysql After correction in my.cnf to: datadir =/var/lib/mysql-500 everything works OK! Fredrik ----- Original Message ----- From: "John Jolet" To: Sent: Sunday, February 05, 2006 3:13 AM Subject: Re: [gentoo-user] ... Can't connect to local MySQL server ... > > On Feb 4, 2006, at 7:37 PM, Fredrik Lundgren wrote: > >> Thanks for the suggestions! >> >> The problem is that >> >> # /etc/init.d/mysql start >> * ... >> * Starting mysql (/etc/mysql/my.cnf) >> * MySQL NOT started (0) [!!] >> >> In my.cnf >> >> .... >> .... >> [client] >> # password = your_password >> port = 3306 >> socket = /var/run/mysqld/mysqld.sock >> ... >> ... >> >> [mysqld] >> ... >> ... >> user = mysql >> port = 3306 >> socket = /var/run/mysqld/mysqld.sock >> .... >> ... >> >> So it appears that /var/run/mysqld/mysqld.sock somehow is corrupted >> How should that be fixed? >> > not necessarily. make sure mysql is not running. check for the > existence of /var/run/mysqld/mysqld.sock...if it exists, delete it. > it shouldn't exist with mysql not running. > >> Fredrik >> >> ----- Original Message ----- From: "John Jolet" >> To: >> Sent: Sunday, February 05, 2006 1:40 AM >> Subject: Re: [gentoo-user] ... Can't connect to local MySQL server >> ... >> >> >>> >>> On Feb 4, 2006, at 6:22 PM, A. Khattri wrote: >>> >>>> On Sun, 5 Feb 2006, Fredrik Lundgren wrote: >>>> >>>>> When I try to visit with >>>>> $ mysql -u root -p >>>>> password. ******* >>>>> >>>>> I get >>>>> ERROR 2002 (HY000): Can't connect to local MySQL server through >>>>> socket >>>>> 'var/run/mysqld.sock' (2) >>>>> >>>>> Evidently my configuration is wrong >>>>> >>>>> Has anyone a tip or two ? >>>> >>>> Maybe start mysqld? >>>> >>>> /etc/init.d/mysql start >>>> >>> and make sure it's still running. and make sure there's an entry >>> for >>> the mysql client in the my.cnf pointing to the proper socket. >>>>> and how do I get mysql to start at boot? >>>> >>>> Maybe use rc-update? >>>> >>>> rc-update add mysql default >>>> >>>> >>>> (Yes, its in the handbook) >>>> >>>> -- >>>> >>>> -- >>>> gentoo-user@gentoo.org mailing list >>>> >>> >>> -- >>> gentoo-user@gentoo.org mailing list >>> >>> >> >> >> -- >> gentoo-user@gentoo.org mailing list >> > > -- > gentoo-user@gentoo.org mailing list > > -- gentoo-user@gentoo.org mailing list