MySQL server PID file could not be found

mac-osxMySQLosx-mountain-lionpid

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

Best Answer

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
Related Topic