Find the answer to your Linux question:
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.
  1. #1
    Linux Engineer RobinVossen's Avatar
    Join Date
    Aug 2007
    Location
    The Netherlands
    Posts
    1,429

    MySQL drop root'@'127.0.0.1


    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
    New Users, please read this..
    Google first, then ask..

  2. #2
    Just Joined! vigour's Avatar
    Join Date
    Oct 2007
    Posts
    68
    Quote Originally Posted by RobinVossen View Post
    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

  3. #3
    Linux Engineer RobinVossen's Avatar
    Join Date
    Aug 2007
    Location
    The Netherlands
    Posts
    1,429
    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.. :/
    New Users, please read this..
    Google first, then ask..

  4. $spacer_open
    $spacer_close

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •