How reset mysql root password as default?

[Lakshmipathi]

When i installed mysql it came with an empty password for the root.

Then i have set root password using, mysqladmin command...

But now i need to reset the password as empty again...(since i need to install few rpms which requires empty password for mysql root) - i don't want to uninstall mysql since i have few databases..


Any idea how to go about this "strange" case

[elija]

Are you sure the RPM's wont ask for the password?

Anyway you can try stopping the MySQL Server and then starting it again with "mysqld_safe --skip-grant-tables" You can then reset the password with the client of choice but don't forget to restart it normally!!

This is how you do it if you forget your password.

You could try logging in as root using your favoured client and then changing the password if you know your root password.

[edit]
Or for commandline "mysqladmin -u root -p oldpassword newpass" although I don't know if will set an empty password
[/edit]

[Lakshmipathi]

Thanks elija . But setting empty password didn't work for me...so finally reinstalled mysql again.
I guess some day , we get answer to this question.
Thanks.