mysql has failed, please contact the sysadmin (result was "mysql is not running").

[brighboss]

I keep recieving this error, mysql will not start. Does any one know how to repair this? All sites on server is down because of this.

 

[arunsv84]

Check the mysql log for possible reasons.

/var/lib/mysql/hostname.err

Also whats the error message that you receive while trying to restart MySQL from backend.

Cheers!!!

 

[Tiger singh]

May the below link will be helpfull to you.

/http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server
Plesae check it and confirm.:D

 

[moleno]

I am also getting the same issue. Today mysql suddenly stopped working. I tried to restart it several times by WHM but failed to start it.
Then I tried it at SSH . It started but with an error.

Please help !!!

==== Error At SSH===
[email protected] [~]# service mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL........................................................................................................ SUCCESS!

====Error at WHM , while trying to restart MySql ===

Waiting for mysql to restart...............finished.

mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/myserver.pid) running as root with PID 3155 (process table check method)
mysqld (/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/myserver.err --open-files-limit=50000 --pid-file=/var/lib/mysql/myserver.pid) running as mysql with PID 3241 (process table check method)

mysql has failed, please contact the sysadmin (result was "mysql is not running").

 

[24x7server]

You will have to kill all current running MySQL process and then start the MySQL, You can check current MySQL process through following command

ps -ef | grep mysqld

 

[moleno]

You will have to kill all current running MySQL process and then start the MySQL, You can check current MySQL process through following command

Mysql is already running but the issue is once I tried to start it by SSH , I got an error . ""ERROR! MySQL manager or server PID file could not be found!"" . what was this ?

==== Error At SSH===
[email protected] [~]# service mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL........................................................................................................ SUCCESS!