Results 1 to 3 of 3
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...
Enjoy an ad free experience by logging in. Not a member yet? Register.
- 11-06-2007 #1
- 11-07-2007 #2
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.
- 11-07-2007 #3
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.
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.. :/