centos下mysql安装完，启动时报错：Starting MySQL. Manager of pid-file quit without updating

襄阳城

<p>centos下mysql安装完，启动时报错：Starting MySQL. Manager of pid-file quit without updating fi[失败]</p>
<p><img src="http://img.baidu.com/img/iknow/icn_point.gif"> 悬赏分：5 -</p>
<p>解决时间：2010-11-9 11:07</p>
<p>执行------service mysqld start</p>
<p>启动，错误显示为：</p>
<p>Starting MySQL. Manager of pid-file quit without updating fi[失败]</p>
<p>日志记录，错误代码如下：</p>
<p>101108 17:06:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data</p>
<p>101108 17:06:13 [Warning] \'--skip-locking\' is deprecated and will be removed in a future release. Please use \'--skip-external-locking\' instead.</p>
<p>101108 17:06:13 [Note] Plugin \'FEDERATED\' is disabled.</p>
<p>/usr/local/mysql/bin/mysqld: Table \'mysql.plugin\' doesn\'t exist</p>
<p>101108 17:06:13 [ERROR] Can\'t open the mysql.plugin table. Please run mysql_upgrade to create it.</p>
<p>InnoDB: Log scan progressed past the checkpoint lsn 0 37356</p>
<p>101108 17:06:13  InnoDB: Database was not shut down normally!</p>
<p>InnoDB: Starting crash recovery.</p>
<p>InnoDB: Reading tablespace information from the .ibd files...</p>
<p>InnoDB: Restoring possible half-written data pages from the doublewrite</p>
<p>InnoDB: buffer...</p>
<p>InnoDB: Doing recovery: scanned up to log sequence number 0 44233</p>
<p>101108 17:06:13  InnoDB: Starting an apply batch of log records to the database...</p>
<p>InnoDB: Progress in percents: 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99</p>
<p>InnoDB: Apply batch completed</p>
<p>101108 17:06:14  InnoDB: Started; log sequence number 0 44233</p>
<p>101108 17:06:14 [Note] Recovering after a crash using mysql-bin</p>
<p>101108 17:06:14 [Note] Starting crash recovery...</p>
<p>101108 17:06:14 [Note] Crash recovery finished.</p>
<p>101108 17:06:14 [ERROR] Fatal error: Can\'t open and lock privilege tables: Table \'mysql.host\' doesn\'t exist</p>
<p>101108 17:06:14 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended</p>
<p>提问者： r61ethinkpad - 五级</p>
<p>最佳答案</p>
<p>pid文件自动关闭，主要可以看日志的error和warning提示操作：</p>
<p>101108 17:06:13 [ERROR] Can\'t open the mysql.plugin table. Please run mysql_upgrade to create it.</p>
<p>不能打开mysql库中的plugin表</p>
<p>101108 17:06:14 [ERROR] Fatal error: Can\'t open and lock privilege tables: Table \'mysql.host\' doesn\'t exist</p>
<p>host表不存在</p>
<p>101108 17:06:13 [Warning] \'--skip-locking\' is deprecated and will be removed in a future release. Please use \'--skip-external-locking\' instead.</p>
<p>加上--skip-external-locking参数重新编译</p>
<p>首先你先查看你的mysql的数据库文件存放位置是否正确，，还有是否有权限</p>
<p>权限设置可以参考下面文章</p>
<p>http://hi.baidu.com/ynnal911/blog/item/248e09b603fd0bc036d3caba.html</p>
<p>其实现在mysql有已编译好的，不用编译，下载下来，简单的配置一下就可以直接使用</p>
<p>下载地址</p>
<p>http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.48-linux-i686-glibc23.tar.gz/from/http://ftp.iij.ad.jp/pub/db/mysql/</p>
<p>1</p>
<p>回答者：</p>
<p>lanny119 - 八级   2010-11-8 18:19</p>
<p>我来评论>></p>
<p>提问者对于答案的评价：</p>
<p>其实，我就是装的你给的下载链接。现在我重新下了一个安装版的，自己编译，安装后，好了。</p>
<p>还是谢谢你。</p>