running mysql and using phpmysql the user table was accidently deleted from sql (how - I'm not for sure, I'm simply cleaning up after it happened) I'm unable to log into mysql via any phpmysql and command line tools such as mysql and mysqladmin won't work either. I tried removing the rpm package and then re-installing it via rpm to no avail?

Any one know of ANY way to solve this that doesn't involve wiping the machine?

-neil

I'm not sure how to get the User table back, but you can easily recompile mysql, and that's all. Check the FAQ's and Manuals, I'm sure they have this kind if situation.

You can get a user table from some other server and copy it over to the appropriate place :) You will need to copy three files (user.MYD, user.MYI, user.frm) that you can find under "/var/db/mysql/mysql" directory. Make sure file permissions are ok after copying.

That's it!

Do not forget to have a backup next time :)

Originally posted by masood
You can get a user table from some other server and copy it over to the appropriate place :) You will need to copy three files (user.MYD, user.MYI, user.frm) that you can find under "/var/db/mysql/mysql" directory. Make sure file permissions are ok after copying.

That's it!

Do not forget to have a backup next time :)


This will only work if you just installed mysql and you previously had no other users added. The other server's User table will contain information about mysql users for that server.