1、Starting MySQL. ERROR! Manager of pid-file quit without updating file.
2、[root@nginx var]# vi /var/log/mysqld.log140306 15:54:31 InnoDB: Started; log sequence number 0 44233140306 15:54:31 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
3、好吧，问题找到了，来修改成之前的数据库位置。[root@nginx var]# vi /etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid
4、到此我以为完成了，因为服务器提示mysql数据库启动成功了，但是依然无法连接到数据库。猜测可能是权限的问题。
5、[mysqld]datadir=/usr/local/mysql/varsocket=/tmp/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid
6、做此修改后，数据库可以正常连接，一切正常！申明：本文由BYRD原创(基于Centos6.4 X64)，未经许可禁止转载！