Resetting the ROOT password in a MySql server

Submitted by johnvsc on December 5, 2009 - 10:22am
in

If you haven't guessed, this blog contains things I need to remember because I make alot of stupid mistakes. This happens often when your brain is a sieve.

Anyhow, so with my last install of WAMP, I decided to be clever and give my 'root' privilege an actual password because I was tired of seeing that error is phpMyAdmin. LOL, well, so after I set it and tried to get into the phpMyAdmin ... I was locked out.

So, if that happens to you, try this:

  1. use the WAMP task bar manager and select the MySQL console or ...
  2. go to mysql prompt withmysql -u root -p
  3. then, use 'mysql' databaseuse mysql;
  4. select, which user to changeselect Host, User, Password from user ;
  5. and change the desired userupdate user set password = '' where user = 'root' and host = 'localhost';

    6. and you should be good to go !