September 24th, 2000, 08:26 PM
Hello all you MySQL experts out there!
I am very very new to MySQL. The installation of MySQL was successful, and I have set a password for root using the command: ./mysqladmin -u root password examplepw
Now my question is: How do I undo that command? I don't want root to have a password. Just like the default for the installation. I've looked around but couldn't find the answer.
I am learning MySQL so security is not an issue now. Thanks in advance.
September 26th, 2000, 01:01 AM
Log into the mysql command prompt (
mysql -uroot -p
and type :-
UPDATE user SET Password='' WHERE User='root';
Make sure you get the case right! The User and user are different as is Password and password
And it should reset the root password
September 26th, 2000, 11:22 PM
Thanks a million Darren!
Boy, that's more involved than I thought. Your suggestion worked on first tried.
September 28th, 2000, 06:26 AM