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

I accidentally deleted the records from the mysql.user table on my mysql server. I didn't flush the privileges yet so I have the root privilege.

Is there a way to recover the table or to create the table from current privileges in memory?

(it's mysql 5 ubuntu 11.04)

share|improve this question
Did you have binary logs enabled ??? If so, do you have all binary logs from the beginning ??? – RolandoMySQLDBA Jul 17 '11 at 19:59

I'm afraid not. You're going to need to restore from backup.

share|improve this answer

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.