Question

Starting MySQL..The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid

实在是头疼 用RPM安装了一个MYSQL5.5 之后，没有在ETC下面生成MY.CNF。但是MYSQL 是能正常启动的。
我在ETC下面放置了 MY.CNF之后。
提示上面的错误。。系统重启过也还是那 。之前的 MYSQL进程已经是关闭了的。
删除MY.CNF之后 ，系统能正常启动了。
大侠们 跪求了。。。。

Answer 1

问题描述： [root@bogon mysql-5.1.41]# /etc/rc.d/init.d/mysqld startStarting MySQL.Manager of pid-file quit without updating file.[失败] --------------------------- 解决办法：配置的时候有一个步骤是 cp support-files/my-medium.cnf /etc/my.cnf ; 就编辑my.cnf,在[mysqld]下面加上：datadir = /usr/local/mysql/data 例如# The MySQL server[mysqld]port = 3306socket = /tmp/mysql.sockskip-lockingkey_buffer_size = 16Mmax_allowed_packet = 1Mtable_open_cache = 64sort_buffer_size = 512Knet_buffer_length = 8Kread_buffer_s ...

2.首先到/usr/local/mysql/data先 chown -R mysql:mysql * 然后杀掉mysql进程，在启动musql就行了

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

4.确实一般都是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.