mysql os.pid_MySQL在OS El Capitan的配置[PID file error]

Installation

使用Homebrew安装：

brew install mysql

bash中显示如下信息，安装成功。

We've installed your MySQL database without a root password. To secure it run:

mysql_secure_installation

To connect run:

mysql -uroot

To have launchd start mysql now and restart at login:

brew services start mysql

Or, if you don't want/need a background service you can just run:

mysql.server start

运行之后显示错误信息

LINSPIRATIONs-MacBook-Pro:~ linspiration$ mysql.server start

Starting MySQL

. ERROR! The server quit without updating PID file (/usr/local/var/mysql/LINSPIRATIONs-MacBook-Pro.local.pid).

Configuration

我没有按照网上大部分的解决方案那样去对local.err或者PID进行修改，而是

1.

//删除usr/local中之前的安装文件夹，并用brew进行卸载

brew uninstall mysql

//如未解决问题，进行下一步

2.

//在bash中找到所有的mysql instance

ps -ef | grep mysql

3.

//关闭进程PID，PID为最后一行的

--pid-file=/usr/local/var/mysql/LINSPIRATIONs-MacBook-Pro.local.pid 501 76360 76349 0 10:08PM ttys000 0:00.00 grep mysql

//中的501 76360 76349

//然后 kill掉它

kill -9 501 76360 76349

4.

//重新运行sql server

mysql.server start

完成！