LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   mysql user table corruption (http://www.linuxquestions.org/questions/linux-software-2/mysql-user-table-corruption-438062/)

creolophus 04-23-2006 02:12 PM

mysql user table corruption
 
Hi all!

i have a problem.

I was just playing around with the MySQL User table, trying to create a new user, change the password, etc. (i know that i shouldn't have!)

Now, the table is corrupted and I dont know how to recover it.



please tell me how to get back to normal again without re-installing MySQL

[because I am using Fedora Core 5 and the 'add/remove software' application doesnt work :( ]

thank you

randyding 04-23-2006 09:12 PM

I don't remember the exact command, but if you delete the user database, then restart mysql it will re-create the default user database.


All times are GMT -5. The time now is 09:07 AM.