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.

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

1 Answer

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

share|improve this answer
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.