MySQL:优胜美地OS更新后El Capitan OS上的错误 [英] MySQL: error on El Capitan OS after Yosemite OS update
问题描述
我在MacBook上遇到MySQL问题.在安装MySQL服务器之前,我已将操作系统从优胜美地更新为El Capitan.
I have problems with MySQL on my MacBook. I had updated my OS from Yosemite to El Capitan before I installed MySQL server.
现在,当我尝试在Terminal上运行MySQL时,出现了这样的错误
Now, when I try to run MySQL on Terminal, I got the error like this
ERROR! The server quit without updating PID file
任何人都可以帮助我吗?非常感谢!
Anyone can help me please? Thanks a lot!
推荐答案
尝试更新my.cnf文件以手动设置PID文件的位置.这是您的操作方式.
Try updating your my.cnf file to set the location of the PID file manually. Here's how you do that.
在终端中运行以下命令.
In your Terminal run the following command.
ps -ax | grep mysql
这将列出重要的mysql文件的所有位置.寻找--pid-file
This will list all the locations of the important mysql files. Look for the path of the --pid-file
我将看起来像这样:
--pid-file=/path/to/your/local/mysqld.local.pid
复制mysqld.local.pid文件的路径
Copy the path of the mysqld.local.pid file
接下来使用nano打开您的my.cnf文件
Next open your my.cnf file using nano
sudo nano /usr/local/mysql/my.cnf
在my.cnf文件的末尾设置pid文件路径.搜索pid文件.如果找不到,请在my.cnf文件末尾手动输入.这将告诉mysql在哪里寻找PID文件.输入您复制的路径,如下例所示.
Set the pid-file path at the end of your my.cnf file. Search for pid-file. If you can't find it, manually enter it at the end of your my.cnf file. This will tell mysql where to look for the PID file. Enter the path that you copied like the example below.
pid-file = /path/to/your/local/mysqld.local.pid
关闭并保存文件
接下来重新启动mysql.您可能需要执行两次以重置PID错误.
Next restart mysql. You may need to do this twice to reset your PID error.
sudo /usr/local/mysql/support-files/mysql.server start
那应该可以解决您的问题!祝你好运
That should solve your problem! Good luck
这篇关于MySQL:优胜美地OS更新后El Capitan OS上的错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!