Re: MySQL is running but PID file could not be found error ?

Posted by ErmanArslansOracleBlog on Aug 27, 2014; 1:05pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/MySQL-is-running-but-PID-file-could-not-be-found-error-tp17p18.html

Hi Başar,

Database category represents Oracle Database :)
But I will try to help you in this case.

Check for the parameter pid-file in the mysql conf
Set your pid file - > pid-file    = /var/run/mysqld/mysqld.pid
Save and exit from the file.
Run the following commands to create the directory , create pid file and configure the ownerships..;
mkdir /var/run/mysqld
touch /var/run/mysqld/mysqld.pid
chown -R mysql:mysql /var/run/mysqld

Restart your mysql..