MySQL服务器启动错误'服务器退出而不更新PID文件' [英] MySQL server startup error 'The server quit without updating PID file'

问题描述

On Mac OS X v10.6 (Snow Leopard), starting MySQL gives the following error:

The server quit without updating PID file

File my.cnf

[mysqld]
port            = 3306

socket          = /tmp/mysql.sock

skip-external-locking

key_buffer_size = 16K

pid-file=/var/run/mysqld/mysqld.pid

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

解决方案

Try to remove the ib_logfile0 and ib_logfile1 files and then run MySQL again:

rm /usr/local/var/mysql/ib_logfile0
rm /usr/local/var/mysql/ib_logfile1

It works for me.

这篇关于MySQL服务器启动错误'服务器退出而不更新PID文件'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！