MySQL drop root'@'127.0.0.1

[RobinVossen]

I kinda dropped all my users from MySQL.
And I have no idea how to put them back.
can anyone help me on this?
Cheers,
Robin

[vigour]

I kinda dropped all my users from MySQL.
And I have no idea how to put them back.
can anyone help me on this?
Cheers,
Robin

I guess you don't have a backup?

If the server doesn't let you in, install a clean mysql server on a separate box and replace the /var/lib/mysql/mysql directory.
If you are using RPM architecture, you can just extract that folder on the place of the old one. Thus you should have the default mysql database with root login with no password.

Cheers,
Ventsi

[RobinVossen]

Ok, thanks I think I have to do that.
The reason that I dont have a back up is since I just installed MySQL.
I tryed umerge -> emerge.
I tryed remerge nothing worked.
But thanks I think I can do that thing you said.
Thanks alot.
Cheers,
Robin

edit:
So I have to change the user.MYD user.MYI and user.frm file?
This box is Gentoo.
I have a spare box that I wanted to use to copy the files from. But thats a Fedora Core 6 box and it doesnt have it.. :/