Mysql修改数据存储目录后，出现The server quit without updating PID file错误。

lyongde

因个人需要，重新设置数据库存储位置，系统CentOS-6.4。
1、安装完成LNMP环境，先/root/lnmp stop停止所有相关服务；
2、重新设置了/etc/my.cnf的datadir = /data/mysql/var；
3、/root/lnmp start启动所有相关服务；

此时出现 Starting MySQL...The server quit without updating PID file [失败]/mysql/var/localhost.localdomain.pid).错误，错误日志如下：

1. 140513 11:59:34 mysqld_safe Starting mysqld daemon with databases from /data/mysql/var
   
2. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
   
3. 140513 11:59:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
   
4. 140513 11:59:34 InnoDB: The InnoDB memory heap is disabled
   
5. 140513 11:59:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
6. 140513 11:59:34 InnoDB: Compressed tables use zlib 1.2.3
   
7. 140513 11:59:34 InnoDB: Initializing buffer pool, size = 16.0M
   
8. 140513 11:59:34 InnoDB: Completed initialization of buffer pool
   
9. InnoDB: The first specified data file /data/mysql/var/ibdata1 did not exist:
   
10. InnoDB: a new database to be created!
    
11. 140513 11:59:34  InnoDB: Setting file /data/mysql/var/ibdata1 size to 10 MB
    
12. InnoDB: Database physically writes the file full: wait...
    
13. 140513 11:59:34  InnoDB: Log file /data/mysql/var/ib_logfile0 did not exist: new to be created
    
14. InnoDB: Setting log file /data/mysql/var/ib_logfile0 size to 5 MB
    
15. InnoDB: Database physically writes the file full: wait...
    
16. 140513 11:59:34  InnoDB: Log file /data/mysql/var/ib_logfile1 did not exist: new to be created
    
17. InnoDB: Setting log file /data/mysql/var/ib_logfile1 size to 5 MB
    
18. InnoDB: Database physically writes the file full: wait...
    
19. InnoDB: Doublewrite buffer not found: creating new
    
20. InnoDB: Doublewrite buffer created
    
21. InnoDB: 127 rollback segment(s) active.
    
22. InnoDB: Creating foreign key constraint system tables
    
23. InnoDB: Foreign key constraint system tables created
    
24. 140513 11:59:35  InnoDB: Waiting for the background threads to start
    
25. 140513 11:59:36 InnoDB: 1.1.8 started; log sequence number 0
    
26. 140513 11:59:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    
27. 140513 11:59:36 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    
28. 140513 11:59:36 [Note] Server socket created on IP: '0.0.0.0'.
    
29. 140513 11:59:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    
30. 140513 11:59:36 mysqld_safe mysqld from pid file /data/mysql/var/localhost.localdomain.pid ended

复制代码

求解，@军哥。
已经尝试以下方法：

1、kill相关进程，重启mysql问题仍然存在；2、清除mysql-bin.index，重启mysql问题仍然存在；3、

selinux未开启；

谢谢，尝试重做两遍了LNMP 问题依然存在。

[ 本帖最后由 lyongde 于 2014-5-13 12:25 编辑 ]

licess

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

lyongde

哪一部份，是指初始数据库吗？

lyongde

军哥，是指\cp -rf /usr/local/mysql/var/* /data/mysql/var，这样吗，已经这样操作，问题依然存在。

lyongde

己解决。

按照@军哥提示，重新拷贝初如文件到目录，并且要设置mysql.mysql权限到所有数据库文件，重启即可。