Find the answer to your Linux question:
Results 1 to 3 of 3
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    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
    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.


    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
    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.

  4. $spacer_open

Posting Permissions

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