Re: mysqld.sock missing
Am Freitag, den 12.08.2005, 16:11 -0500 schrieb Mannequin*:
> On Fri, 12 Aug 2005 15:06:44 +0200
> Daniel Leidert <firstname.lastname@example.org> 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: 050812 15:39:44 [ERROR] /usr/sbin/mysqld:
> Incorrect information in file: './mysql/user.frm'
> Aug 12 15:39:44 cora mysqld: 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?