数据库出现损坏，无法开启进程
以下是错误报告，请军哥帮忙解决下，谢谢。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 Event Scheduler: Loaded 0 events
110920 13:15:10 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
110920 18:09:12 /usr/local/mysql/libexec/mysqld: Normal shutdown
110920 18:09:12 Event Scheduler: Purging the queue. 0 events
110920 18:09:12 /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 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:09:56 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 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:23:31 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 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:26:20 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 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:28:03 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 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:29:53 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 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 18:31:21 Can't start server : Bind on unix socket: Address already in use
110920 18:31:21 Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
110920 18:31:21 Aborting
110920 18:31:21 /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 如果是新安装的应该是/usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql
这一步报错了。
可以执行 /usr/local/mysql/bin/mysql_upgrade 试试
/tmp/mysql.sock 是存在的，好像已经有mysql在运行
回复 2# 的帖子
军哥，/tmp/mysql.sock 是我后来自己添加进的。之后又被我删除了。下面是执行/usr/local/mysql/bin/mysql_upgrade命令的情况:# /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
回复 2# 的帖子
LNMP的状态如下显示:# /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 刚安装好还是已经用过一段时间了？
查进程里是否有其他的mysql在运行
回复 5# 的帖子
刚安装好的。后来我删除了一些数据库表，并且因为网络问题，正在往服务器上传的压缩包没上传完就断开连接了，国内的网络环境真是恶劣啊。然后强制关闭了ie。没有其他的mysql进程在运行。看来问题挺严重，我再花半天时间把整个系统重做下吧。
谢谢军哥的解答。
页:
[1]