[Help] Cpanel : Starting MySQL. ERROR! Manager of pid-file quit without updating file

[zeroseven]

This problem has been 3 days.

I get this problem via email every 5 minutes ;

mysql failed @ Wed Oct 2011. A restart was attempted automagically.

Service Check Method:  [check command]

Number of Restart Attempts: 

Cmd Service Check Raw Output: mysql is not running

Startup Log: Starting MySQL. ERROR! Manager of pid-file quit without updating file.

All my site in this server running wordpress now showing ;

Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

The mysql simply wont start. Doing anything form cpanel and ssh, start/stop mysql doesnt help. Please any help guys.

Thanks a lot.

 

[Loonycgb2]

Your mysql installtion has corrupted... Have you tried either backing up all your dbs and reinstalling or upgradeing to a newer version of mysql???

Sometimes mysql needs to be reconfigured if more processes are coming in...
If it wont start run the command "ps aux" find the mysql process name and do a "killall process" (killall mysql)...

Then try starting mysql again..

 

[zeroseven]

i've tried "ps aux" and there aren't any mysql process. starting/restarting mysql again but still that error appeared. Any other solution guys?

 

[Sonic]

if you have access to WHM you can rebuild the server with Easy Apache 2.0. It install PHP, apache and other mods

Good luck

 

[zeroseven]

i have access to WHM and tried build the server via easy apache with default setting but the result still the same. mysql wont start still that message appeared. Damn whats really happening. servedome support even terrible to just reply my ticket.

 

[zeroseven]

Here is the more error log. Really Hope someone can find any solution for me.

111019 14:38:02  mysqld started
111019 14:38:02 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

111019 14:38:02 [ERROR] Aborting

111019 14:38:02 [Note] /usr/sbin/mysqld: Shutdown complete

111019 14:38:02  mysqld ended

111019 14:43:03  mysqld started
111019 14:43:03 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

111019 14:43:03 [ERROR] Aborting

111019 14:43:03 [Note] /usr/sbin/mysqld: Shutdown complete

111019 14:43:03  mysqld ended

111019 14:48:05  mysqld started
111019 14:48:05 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

111019 14:48:05 [ERROR] Aborting

111019 14:48:05 [Note] /usr/sbin/mysqld: Shutdown complete

111019 14:48:05  mysqld ended

111019 14:53:05  mysqld started
111019 14:53:05 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

111019 14:53:05 [ERROR] Aborting

111019 14:53:05 [Note] /usr/sbin/mysqld: Shutdown complete

111019 14:53:05  mysqld ended

111019 14:57:01  mysqld started
111019 14:57:01 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.92-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

The line just keep repeating.

Any help guys.