大网数据广告活动
服务器运维问答

MySQL server PID file could not be found

· 52CE 我爱测

I can start MySQL fine, /usr/local/mysql/support-files/mysql.server start Starting MySQL SUCCESS! But any MySQL action after that I get the error: MySQL server PID file could not be found /usr/local/mysql/support-files/mysql.serv…

问题原文

原帖链接 · simpleengine · CC BY-SA 4.0

I can start MySQL fine,

/usr/local/mysql/support-files/mysql.server start
Starting MySQL
SUCCESS! 

But any MySQL action after that I get the error:

MySQL server PID file could not be found

/usr/local/mysql/support-files/mysql.server stop
ERROR! MySQL server PID file could not be found!

Where do I find the server PID file on Mac with OSX 10.8? I am wondering if it is a permission problem. The mysql.sock file is a symlink pointing to the file in the tmp/ directory.

sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

已采纳解答

原帖链接 · Daniel t. · CC BY-SA 3.0

In your mysql configuration file - my.cnf, check for the parameter pid-file and see where it points. If it is not there, set it manually to -

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

Create the directory /var/run/mysqld/ and give it proper permissions -

  mkdir /var/run/mysqld
  touch /var/run/mysqld/mysqld.pid
  chown -R mysql:mysql /var/run/mysqld

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2013-02-20)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0 / CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。