Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does anyone know if a power outage could somehow have corrupt the mysql logins? We had an outage the other day, my mysql logins no longer work. The mysql process seems to be running fine.

Any idea how I can recover from my current predicament!


It now seems the user account no longer exists!


share|improve this question

The power failure can cause some mysql tables to be marked as corrupted and should be checked. Before that, you will not be able to query such tables. I remember I faced a similar problem of corrupted tables. Most likely, the tables with ongoing updates will suffer from such an error.

I suggest that you restart mysql with the option --skip-grant-tables to be able to login. Then, you can check the tables under mysql database. Also, you can change any user password.

For MyISAM tables, you can do something like:

mysql> repair table <table_name>;
share|improve this answer
It seems the account in question no longer exists in the user table (I found a debian-sys-maint account in the system dirs). – steve Dec 11 '11 at 16:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.