taroon-list@redhat.com
[Top] [All Lists]

Re: strange MySQL problem /var/lib/mysql/ become empty

Subject: Re: strange MySQL problem /var/lib/mysql/ become empty
From: Helmut Wirth
Date: Tue, 08 Mar 2005 20:09:47 +0100
Chris Vanhoof wrote:
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Leuy Eeelyu wrote:
> | Hi.  I have very strange MySQL problem in RHEL. I used
> | to use command line MySQL monitor and MySQLCC to
> | access MySQL. But I thought of installing phpmyadmin,
> | because of that, it prompt me to install php-mysql as
> | the software require it. But after installation, I
> | found I can't access MySQL using command line anymore
> |
> | "linux# mysql -u root -p
> | password:
> | ERROR 2002: Can't connect to local MySQL server
> | through socket '/var/lib/mysql/mysql.sock' (2)
> |
> | But STRANGE thing is I can still reconnect using
> | MySQLCC and do whatever I want
> |
> | and I found my /var/lib/mysql become empty. How to
> | solve it? I tried to copy /var/lib/mysql/ from another
> | MySQL server but the mysql.sock cannot be copied as it
> | is srwxrwxrwx.
> |
> | What should I do ???
> 
> It doesnt sound like the daemon is running at all...  Have you tried
> restarting it?
> 
looks more that the httpd user under which mysql is running
(apache?) has no permission to read/write the mysql socket file.

Ciao,
-- 
Helmut Wirth

wirth@xxxxxxxxxxxxx
-------------------------------------------------------------
bison GmbH                         phone +49 89 / 50 03 91-14
Planegger Str. 16                  fax   +49 89 / 50 03 91-17
D-82110 Germering                  http://www.bison-soft.de/
-------------------------------------------------------------

--
Taroon-list mailing list
Taroon-list@xxxxxxxxxx
http://www.redhat.com/mailman/listinfo/taroon-list

<Prev in Thread] Current Thread [Next in Thread>