mysql启动问题,急救！！！

zhouybox

我以前一直在用的mysql崩溃了（
而且用/etc/rc.d/init.d/mysqld start failed
进程中已经没有mysql的进程
用mysqladmin version显示
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
#ls -l /var/lib/mysql/
发现 mysql.sock 为0字节
/tmp 下没有mysql.sock 文件
用safe_mysqld 也不成
把mysql卸掉重装也是老样子



注：我用的是redhat7.3，先装apache-1.3+php-4.12（和系统一起安装） 后来用rpm装mysql-3.23，还装了phpmyadmin,曾运行过一段时间,没出现问题

再加一句
/etc/rc.d/init.d/mysqld status

mysqld dead but subsys locked

以下是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 #此文件不存在

以下为/var/log/mysqld.log.1文件里的末尾几行

lock: 84a621c:

lock: 83e49d4:

lock: 8425064:

lock: 852f964:

lock: 85a3684:

lock: 847ac1c:

lock: 846cbc4:

lock: 840368c:

lock: 8431f4c:

lock: 8464924:

key_cache status:
blocks used: 1640
not flushed: 0
w_requests: 20649
writes: 17043
r_requests: 1252665
reads: 1112

handler status:
read_key: 236819
read_next: 125745
read_rnd 218518
read_first: 19805
write: 15880
delete 426
update: 15154

Table status:
Opened tables: 3208
Open tables: 64
Open files: 123
Open streams: 0
030520 11:22:24 /usr/libexec/mysqld: Normal shutdown

030520 11:22:24 /usr/libexec/mysqld: Shutdown Complete