Accidently Deleted MySQL root usr

[jnedobity]

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

[jlgreer1]

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.

[jnedobity]

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.