mysqld fails to startup on Fedora Core 3

[wnqq]

Dear There,

I could not successfully start up mysqld. Hope someone can help me.

My Environment:
* Fedora Core 3 (fully up2dated as of 11/30/2004)
* Related installed packages (from Red Hat):
mysql-server-3.23.58-13
mysql-3.23.58-13
mysql-devel-3.23.58-13
php-mysql-4.3.9-3

I have tried the following 3 commands to startup mysqld, but none of them work. The results are shown below for each command, respectively.

(1)
[root@al390x ~]# safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
041130 23:19:27 mysqld ended

(2)
[root@al390x ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
啟動 MySQL: [失敗]

(The last line above says "starting MySQL failed".)

(3)
[root@al390x ~]# /etc/init.d/mysqld start
[Same result as (2)]

If I check its status as follows:

[root@al390x ~]# service mysqld status
mysqld 停止執行但 subsys 已鎖定

(The last line above says: "mysqld dead but subsys locked".)

So, I have to execute the following command to unlock it:
# rm /var/lock/subsys/mysqld

My configuration /etc/my.cnf:
-------------------------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
-------------------------------------------

The log file /var/log/mysqld.log:
-------------------------------------------
041130 22:50:04 mysqld started
041130 22:50:04 mysqld ended

041130 23:16:09 mysqld started
041130 23:16:09 mysqld ended

041130 23:18:37 mysqld started
041130 23:18:37 mysqld ended
......[snip]......
-------------------------------------------

I have spent hours googling this problem, but have got no clues yet.

Any help will be highly appreciated.

Thank you.

Best Regards,

WNQQ