mysql错误，MySQL server PID file could not be found! 求解。

lyongde

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 [ERROR] 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:50  InnoDB: 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:50  InnoDB: Waiting for the background threads to start
140513 10:51:51 InnoDB: 1.1.8 started; log sequence number 1595675
140513 10:51:51 [Note] Recovering after a crash using mysql-bin
140513 10:51:51 [Note] Starting crash recovery...
140513 10:51:51 [Note] Crash recovery finished.
140513 10:51:51 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140513 10:51:51 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140513 10:51:51 [Note] Server socket created on IP: '0.0.0.0'.
140513 10:51:51 [ERROR] 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 编辑 ]

licess

数据库cp过去的时候部分数据丢失，重新cp