Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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!

[Edit]

It now seems the user account no longer exists!

[/edit]

share|improve this question
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.