Mysql
 

hey we just installed mysql with redhat we boot mysql it says it works fine so

[root@server bin]# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

then

[root@server bin]# /etc/init.d/mysqld status
mysqld dead but subsys locked

any ideas on whats going on?

im running redhat 9

If I can remember correctly, this error shows that the previous mysql session did not terminate correctly and left behind the lock. Mysql is not running in the first place (try ps -ef | grep mysql).

Try stopping mysql (although it is not running, just trying to get rid of the lockfile the nice way) with: /etc/init.d/mysqld stop.

Check the logfiles and check to see if there still is a lockfile. If the lockfile is still there, remove it and try starting mysql again.

Hope this put you on the right track.

mysqld dead but subsys locked
 

clicky clicky searchy searchy . . .

Problem Resolution -for some?

More resolution . . .

This worked on my system too after upgrading mysql. Seems it was something with selinux. Still, I'm a newbie so, if this resolution poses security issues...paleez let me know.

Hope this helps...

Apexdv
Professional Newbie