Am Freitag, den 12.08.2005, 16:11 -0500 schrieb Mannequin*: > On Fri, 12 Aug 2005 15:06:44 +0200 > Daniel Leidert <[EMAIL PROTECTED]> wrote:
[..] > > > Last night I believe I upgraded mysql. Now whenever I try and use mysql, I > > > get this error: > > > > > > > ~$ mysql > > > > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > > > > '/var/run/mysqld/mysqld.sock' (2) [..] > Here is what '/etc/init.d/mysql start' says: > > > /var/lib/mysql/mysql# /etc/init.d/mysql start > > Starting MySQL database server: mysqld...failed. > > Please take a look at the syslog. > > /usr/bin/mysqladmin: connect to server at 'localhost' failed > > error: 'Can't connect to local MySQL server through socket > > '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the > > socket: '/var/run/mysqld/mysqld.sock' exists! > > I've posted what syslog says at the bottom of this email. > [..] > > > My system is a PB G3 Firewire (Pismo) running Debian/Etch. Any help would > > > be > > > appreciated. > > > > If mysqld does not start, you should have a look at the syslog. > > I have now looked at the syslog. It's looking like > /var/lib/mysql/mysql/user.frm > is corrupt in some way. Right, this seems to be the reason. [..] > Aug 12 15:39:44 cora mysqld[6847]: 050812 15:39:44 [ERROR] /usr/sbin/mysqld: > Incorrect information in file: './mysql/user.frm' > Aug 12 15:39:44 cora mysqld[6847]: 050812 15:39:44 [ERROR] Fatal error: Can't > open privilege tables: Incorrect information in file: './mysql/user.frm' [..] If permissions for this file are right, you should ask on a mysql list on how to repair this file or what could have been caused this problem. But maybe it's "only" a problem with the file-system. Can you check (and maybe repair) your fs? Regards, Daniel -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
