Digital Your Life

Forgetting your mysql root password ? that’s a bad thing, but the good news it’s very easy to reset mysql root password. The only thing you need are having enough privillage to do below steps.

1. Log on to your system as Administrator
2. Stop MySQL server if it is running. For MySQL server running as service you can go to Start Menu -> Control Panel -> Administrative Tool -> Services. Find MySQL services and stop it.
3. Start your mysql server using command

   mysqld --skip-grant-tables

   You see your mysql is running now.

4. Login to your mysql using root password by typing this command

   mysql --user=root mysql

   Voila…. you can enter to your mysql without root password.

5. Change your root password by typing this command

   update user set Password=PASSWORD('new-password') where user='root';
   flush privileges;
   exit;

Restart your MySQL server normally, your password has been change using step number five. Good Luck.

Applied to Windows XP