mysql错误，MySQL server PID file could not be found! 求解。
LNMP环境，修改/etc/my.cnf配置文件后，重启mysql，出现如下错误：MySQL server PID file could not be found! [失败]
Starting MySQL..The server quit without updating PID file ([失败]mysql/var/localhost.localdomain.pid).
错误日志如下：
140513 10:51:50 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140513 10:51:50 InnoDB: The InnoDB memory heap is disabled
140513 10:51:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140513 10:51:50 InnoDB: Compressed tables use zlib 1.2.3
140513 10:51:50 InnoDB: Initializing buffer pool, size = 16.0M
140513 10:51:50 InnoDB: Completed initialization of buffer pool
140513 10:51:50 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140513 10:51:50InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140513 10:51:50InnoDB: Waiting for the background threads to start
140513 10:51:51 InnoDB: 1.1.8 started; log sequence number 1595675
140513 10:51:51 Recovering after a crash using mysql-bin
140513 10:51:51 Starting crash recovery...
140513 10:51:51 Crash recovery finished.
140513 10:51:51 Server hostname (bind-address): '0.0.0.0'; port: 3306
140513 10:51:51 - '0.0.0.0' resolves to '0.0.0.0';
140513 10:51:51 Server socket created on IP: '0.0.0.0'.
140513 10:51:51 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
140513 10:51:51 mysqld_safe mysqld from pid file /data/mysql/var/localhost.localdomain.pid ended
求@军哥，求解。
[ 本帖最后由 lyongde 于 2014-5-13 11:02 编辑 ] 数据库cp过去的时候部分数据丢失，重新cp
页:
[1]