Find the answer to your Linux question:
Results 1 to 3 of 3
Well i did not delete the usr but i did delete the password accidently. So now i cant login. is their a way to recover myql .. or should i ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    May 2005
    Posts
    36

    Accidently Deleted MySQL root usr


    Well i did not delete the usr but i did delete the password accidently.


    So now i cant login. is their a way to recover myql .. or should i just reinstall the os. takes 20 mins tops. its just a pain in the ass.

    and i need mysql asap.


    i tried the command to use mysqladmin to change it but all i got was

    Access denied for user ' ' @ localhost to database 'mysql' any idea how to fix this...

    If i cant get'er working i'll reinstall the os...

    Thanks in advanced

  2. #2
    Linux Newbie
    Join Date
    Feb 2005
    Location
    Texas
    Posts
    168
    Login as root and then execute the command:

    GRANT ALL ON database.* TO user@localhost IDENTIFIED BY 'password';

    Don't forget the quotes on the password.

    Jeff

    If you lost your root password there are ways to recover by going into single user mode or using a rescue disk.
    Registered Linux User #391940

  3. #3
    Just Joined!
    Join Date
    May 2005
    Posts
    36
    tried it.... there are no passwords in the mysql db at all...

    and since i still had probs.. i just reinstalled the server os.

    it was easy just annoyning.

Posting Permissions

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