数据库出现损坏，无法开启进程

wintone

以下是错误报告，请军哥帮忙解决下，谢谢。

110920 13:14:17 mysqld_safe mysqld from pid file /usr/local/mysql/var/li333-152.pid ended
110920 13:15:09 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110920 13:15:10 [Note] Event Scheduler: Loaded 0 events
110920 13:15:10 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
110920 18:09:12 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown
110920 18:09:12 [Note] Event Scheduler: Purging the queue. 0 events
110920 18:09:12 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
110920 18:09:12 mysqld_safe mysqld from pid file /usr/local/mysql/var/li333-152.pid ended
110920 18:09:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110920 18:09:55 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:09:56 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110920 18:09:56 mysqld_safe mysqld from pid file /usr/local/mysql/var/li333-152.pid ended
110920 18:23:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110920 18:23:31 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:23:31 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110920 18:23:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/li333-152.pid ended
110920 18:26:20 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110920 18:26:20 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:26:20 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110920 18:26:20 mysqld_safe mysqld from pid file /usr/local/mysql/var/li333-152.pid ended
110920 18:28:03 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110920 18:28:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:28:03 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110920 18:28:03 mysqld_safe mysqld from pid file /usr/local/mysql/var/li333-152.pid ended
110920 18:29:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110920 18:29:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:29:53 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110920 18:29:53 mysqld_safe mysqld from pid file /usr/local/mysql/var/li333-152.pid ended
110920 18:31:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110920 18:31:21 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:31:21 [ERROR] Can't start server : Bind on unix socket: Address already in use
110920 18:31:21 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
110920 18:31:21 [ERROR] Aborting
110920 18:31:21 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
110920 18:31:21 mysqld_safe mysqld from pid file /usr/local/mysql/var/li333-152.pid ended

licess

如果是新安装的应该是/usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql
这一步报错了。

可以执行 /usr/local/mysql/bin/mysql_upgrade 试试

/tmp/mysql.sock 是存在的，好像已经有mysql在运行

wintone

军哥，/tmp/mysql.sock 是我后来自己添加进的。之后又被我删除了。下面是执行/usr/local/mysql/bin/mysql_upgrade命令的情况:

[root@li333-152 ~]# /usr/local/mysql/bin/mysql_upgrade
Looking for 'mysql' as: /usr/local/mysql/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/mysql/bin/mysqlcheck
Running 'mysqlcheck with default connection arguments
/usr/local/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

wintone

LNMP的状态如下显示:
[root@li333-152 ~]# /root/lnmp status
=========================================================================
Manager for LNMP V0.7  ,  Written by Licess
=========================================================================
LNMP is a tool to auto-compile & install Nginx+MySQL+PHP on Linux
This script is a tool to Manage status of lnmp
For more information please visit http://www.lnmp.org

Usage: /root/lnmp {start|stop|reload|restart|kill|status}
=========================================================================
Nginx is runing!
php-fpm is runing!
ERROR! MySQL is not running, but lock exists

licess

刚安装好还是已经用过一段时间了？

查进程里是否有其他的mysql在运行

wintone

刚安装好的。后来我删除了一些数据库表，并且因为网络问题，正在往服务器上传的压缩包没上传完就断开连接了，国内的网络环境真是恶劣啊。然后强制关闭了ie。
没有其他的mysql进程在运行。看来问题挺严重，我再花半天时间把整个系统重做下吧。

谢谢军哥的解答。