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)

link|improve this question

0% accept rate
Did you have binary logs enabled ??? If so, do you have all binary logs from the beginning ??? – RolandoMySQLDBA Jul 17 '11 at 19:59
feedback

1 Answer

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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