Dear firends,
I just installed MySQL 4.1 but when I try to start mysqld I got three messages in different caes:

1 )
service mysqld start
Starting MySQL: [ OK ]
2 )
service mysqld status
mysqld dead but subsys locked
3 )
service mysqld stop
Shutting down MySQL server [FAILED]

Please note that when I check out my open ports it seems that Mysql is not running and the above mentioned OK message is not correct.
In addition there is not log in /var/lib and one other important point is that I found the following thread and I did its recommendations withouth any income.

https://bugzilla.redhat.com/bugzilla...g.cgi?id=14947

This condition is very confusing because it seems that Redhat Bugzilla is not so correct!
Thank you for any comment,

Hi,

Two more treads that talk about your problem.


http://info.ccone.at/INFO/Mail-Archi.../msg01220.html
http://forums.fedoraforum.org/showth...531#post311531

Hope it can help,

Dear friend,
I tested all of the suggested solutions in above links,but none of them solves the problem.It seems that there is no solution to this issue due to the lack of any reference even the Redhat bugzilla's solutiuon will not solve this problem.
Anyway,I have provided more information regarding this error message :

mysqld restart
Shutting down MySQL server [FAILED]
Starting MySQL: [ OK ]

LOG :
Aug 29 12:39:35 fed08 mysqld: Starting MySQL: succeeded
Aug 29 12:39:40 fed08 mysqld: mysqld shutdown failed

ps -aux | grep mysqld
Warning: bad syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
root 5431 0.0 0.2 4584 592 pts/3 S 12:33 0:00 grep mysqld

service mysqld status
mysqld dead but subsys locked

As you can see the starting title is just a fake!
PLASE HELP ME!

Did you tryed mysql safe ? ( safe_mysqld )

Dear my friend,
As the another stage of this strange problem I found no file for safe_mysqld
#################################################################
[root@myfed src]# find / -name safe_mysqld
/var/tmp/MySQL-4.1.14-build/usr/bin/safe_mysqld

[root@myfed src]# /var/tmp/MySQL-4.1.14-build/usr/bin/safe_mysqld
The file /usr/sbin/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there as follows:
./bin/mysqld_safe.
See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html for more
information
#################################################################
Thank you for any comment,

I did encounter this problem too... I fixed it by checking who owns the /var/run/mysqld... It should be own by mysql.

# chown -R mysql.mysql /var/run/mysqld

Hope this fixes your problems too...

The method rching23 said takes effect on my computer! Thank you very much!

Which distro are you running? MySQL 4.1 is old, you should have at least 5.0 by now. Are you running Fedora 8 ( 'fed08 ' )? If so, that distro version is defunct ie no longer updated. Current versions are 10 & 11, 12 due out next mth I believe.

Hi! My platform is as follow：

mysql: mysql Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 4.3

distros: redhat enterprise linux(RHEL)

kernel: 2.6.9-11.ELsmp

Just for completeness, lets see the RHEL version

cat /etc/redhat-release

[root@node37 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 1)

That explains the old MySQL. You've got RHEL 4.1. You might want to put that in your profile for future qns.
Incidentally, the latest v4 is 4.8 & the latest RHEL (overall) is 5.4. Maybe time for an upgrade?

Thank you for your advice!

There's a little tip of my own. Whenever something strage happens, allways check if you have free disk space. If I read this advice while searching for an answer to the same problem five minutes ago, my website would be up 5 minutes earlier.