启动MYSQL出错 Manager of pid-file quit without updating file.

iinbase

Starting MySQL..... ERROR! Manager of pid-file quit without updating file.

这是安装包：
MySQL-server-community-5.0.67-0.rhel4.i386.rpm

用的是 : rhel4
请帮忙看看是什么问题

ruochen

log里面有哪些信息？

denniswwh

打开/etc/selinux/config，把SELINUX=enforcing改为SELINUX=disabled后存盘退出重启机器试试

ruochen

原帖由 denniswwh 于 2008-9-1 10:29 发表
打开/etc/selinux/config，把SELINUX=enforcing改为SELINUX=disabled后存盘退出重启机器试试

有可能是这个问题

barry_zhu

[root@sfn ~]# tail -f /var/lib/mysql/sfn.linux.com.err
090820 03:51:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090820  3:51:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090820  3:51:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
090820 03:51:07 mysqld_safe mysqld from pid file /var/lib/mysql/sfn.linux.com.pid ended
090820 03:51:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090820  3:51:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090820  3:51:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
090820 03:51:50 mysqld_safe mysqld from pid file /var/lib/mysql/sfn.linux.com.pid ended

根本没安装成功

cenalulu

贴一下像楼上那样的error.log，才能判断

expert1

cat /path-your-mysql-data/$hostname.err
把错误日志谷歌一下都能解决的。

expert1

晕，发错位置了，再起一贴吧。

[ 本帖最后由 expert1 于 2009-8-20 14:24 编辑 ]

signmem

通常是由于 my.cnf 配置问题出现的.

iamblackwolf

确实一般都是my.cnf配置文件的问题
/etc/my.cnf来自以下文件：

如果你的内存≤64M，则复制/usr/local/share/mysql/my-small.cnf为/etc/my.cnf
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.

如果内存是128M，则复制/usr/local/share/mysql/my-medium.cnf为/etc/my.cnf
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)

如果内存是512M，则复制/usr/local/share/mysql/my-large.cnf为/etc/my.cnf
# This is for a large system with memory = 512M where the system runs mainly
# MySQL.

如果内存是1-2G，则复制/usr/local/share/mysql/my-huge.cnf为/etc/my.cnf
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.