Mysql – How to fix broken MySQL server

MySQL

I've already looked a lot for this issue but coudn't find the answer, I hope you can help me

I was working on a Windows 2008 Server using some python scripts to update and compute some values from a few mysql tables, stored on MySQL Server 5.5.

But we had a power failure which turned off the computer and when we turned it on again, everything was fine, but we totally lost connection to MySQL. Basically any attempt to run mysql service brings up this message:

http://imageshack.us/photo/my-images/718/mysqlerror.png/

The mysqld service is not running. We''ve tried to restart it, basically by following the steps presented in the mysql documentation site:

dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html

and

dev.mysql.com/doc/refman/5.5/en/starting-server.html

But nothing fixed the problem. When typing net start mysql, i get the message:

"System Error 5. Access Denied"

After reading the documentation, I've found this command: mysqld –debug, which presented the message:

http://imageshack.us/photo/my-images/833/mysqlddebug.png/

I don't know if this message can give any hint of what's actually going on, I hope it does. We've tried everything we've found on the internet: restarting the server, resintalling mysql server, running updates and so on, but the mysql service still won't start.

And no error log was created at all…(but we still don't know if our tables are ok)

Running a mysqlcheck on all databases, I've got the following message:

"mysqlcheck: Got Error 2003: Can't connect to Mysql Server on 'localhost' (10061) when trying to connect".

Does anyone know how to fix it or at least know how to restore the tables we already had before the power outage?

I really appreciate any help! And if you need some more information please let me know! Tnx!

Best Answer

Try running the command prompt as administrator. You should be able to right-click the command prompt shortcut and click "Run as administrator."

Then, do the commands you tried earlier.