Geeks Terminal

While restarting MySQL service, you may get a error

“MySQL is running but PID file could not be found”

Let us see how to fix this error:

• Login to the server as a root user with SSH

• Create the directory var/run/mysql

#mkdir /var/run/mysql

• Now create  file mysqld.pid

#touch mysqld.pid

and change its ownership to  mysql:mysql

#chown mysql:mysql mysqld.pid

• Restart MySQL service and you will see no more error

If any feedback, queries are always welcome!

Abhijit Sandhan

The author is a Linux System Administrator and likes to blog.

    

Find helpful? Spread it!

• 

Related posts:

1. Import error: The used command is not allowed with this MySQL version
2. Cpanel Error : cpsrvd dead but pid file exists
3. MySQL Database my.cnf Optimization with MySQLTuner