通过Brew安装MySQL之后，出现错误-服务器退出而不更新PID文件 [英] After MySQL install via Brew, I get the error - The server quit without updating PID file

问题描述

好吧，我到处搜索，花了很多时间安装，卸载，尝试各种选项，但没有成功.

我在Mac OS X Lion(10.7.3)上，正在尝试设置Python，MySQL.

我通过HomeBrew成功安装了Python和MySQL. Python很棒.

在安装MySQL之后，我按照前两个步骤进行操作-取消设置和mysql_install_db命令.

现在，当我尝试启动mysql"mysql.server start"时，出现以下错误

ERROR! The server quit without updating PID file (/usr/local/var/mysql/Brajeshwar.local.pid).

• Brajeshwar是我在计算机上的用户名.

解决方案

编辑2012/09/18: 如由凯恩(Kane)指出，请确保正确设置mysql数据库，然后再执行其他操作.有关更多信息，请参见" mysql.server启动上的PID错误?". /p>

为历史保留原始答案: 它很可能是 权限问题.检查/usr/local/var/mysql/*.err.我的说:

120314 16:30:14  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
120314 16:30:14 mysqld_safe mysqld from pid file /usr/local/var/mysql/janmoesen.local.pid ended

我还必须这样做:

sudo chown _mysql /usr/local/var/mysql/*

Ok, I've searched all over and have spent quite a bit of my time installing, uninstalling, trying various option but without success.

I'm on Mac OS X Lion (10.7.3) and am trying to setup a Python, MySQL.

I successfully installed Python and MySQL via HomeBrew. Python works great.

After MySQL Installation, I followed the first 2 steps - unset and the mysql_install_db commands.

Now, when I try to start mysql "mysql.server start", I get the following error

ERROR! The server quit without updating PID file (/usr/local/var/mysql/Brajeshwar.local.pid).

• Brajeshwar is my username on my machine.

解决方案

EDIT 2012/09/18: As pointed out by Kane, make sure the mysql database is properly set up before doing anything else. See "PID error on mysql.server start?" for more info.

Original answer kept for history's sake: It most likely is a permissions issue. Check /usr/local/var/mysql/*.err. Mine said:

120314 16:30:14  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
120314 16:30:14 mysqld_safe mysqld from pid file /usr/local/var/mysql/janmoesen.local.pid ended

I also had to do this:

sudo chown _mysql /usr/local/var/mysql/*

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