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.60) (envelope-from ) id 1GcQrY-0006EX-WA for garchives@archives.gentoo.org; Tue, 24 Oct 2006 18:18:57 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.6) with SMTP id k9OIGomD017435; Tue, 24 Oct 2006 18:16:50 GMT Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by robin.gentoo.org (8.13.8/8.13.6) with ESMTP id k9OIEB2O006540 for ; Tue, 24 Oct 2006 18:14:12 GMT Received: by nf-out-0910.google.com with SMTP id p46so407947nfa for ; Tue, 24 Oct 2006 11:14:11 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=IznMO9CuB3VDmOoEiHqQjG9qWKSa1Q2eFi62k717HEOMSZKYnehsdsMmVuk4e0hyMYTj94y5ekJQEB6F783ROCIq5FSPf9zoQ/nhelJW4MYFK8cG4kHi4IdqndELOBi+8il5PCfUhF+PSGrWi+Q4R6Sy7UnvjxGYS1e5Mz3bTMU= Received: by 10.82.126.19 with SMTP id y19mr2143011buc; Tue, 24 Oct 2006 11:14:11 -0700 (PDT) Received: by 10.82.129.11 with HTTP; Tue, 24 Oct 2006 11:14:10 -0700 (PDT) Message-ID: <7e7f5e710610241114i31c8af73v22f7c411d4b770b7@mail.gmail.com> Date: Tue, 24 Oct 2006 14:14:10 -0400 From: "A. R." To: gentoo-user@lists.gentoo.org Subject: [gentoo-user] Weird mysql problem. 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; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Archives-Salt: 0566b58e-86d8-4e10-8a2e-b9509e02b8e9 X-Archives-Hash: dab8a50dec92833c8c2183b7fbe5352b Hi, I am running Gentoo ~amd64 and I recently upgraded MySQL from 5.0.26 to 5.0.26-r1 and things are not working anymore (for example mythtv). After spending a great deal of time looking at logs, changing configuration files (namely, my.cnf), installing and de-installing MySQL, I still cannot get any programs to connect to mysql, including "mysql_secure_installation" which outputs the following error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ''/var/run/mysqld/mysqld.sock'' (2) But, here is the thing, the socket and pid file values in /etc/mysql/my.cnf are set to the following: [client] socket = /tmp/mysqld.sock . . [mysqld] socket = /tmp/mysqld.sock pid-file = /tmp/mysqld.pid And, after re-starting the MySQL process (/etc/init.d/mysql restart) I list the processes and find that the mysqld daemon has indeed been passed the correct configuration values. mysql 24056 1 0 11:20 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/storage/mysql-db --pid-file=/tmp/mysqld.pid --socket=/tmp/mysqld.sock Could someone please help? I know I am running ~arch and that this is perhaps "part of the game" in doing that, but maybe it can be easily fixed... Thank you, - AR -- If you stare long enough into an abyss, the abyss will stare back into you... -- gentoo-user@gentoo.org mailing list