Reset MySQL password for Windows Vista

Author

shabbir ( Go4Expert Founder )

Shabbir is a developer in the field of Applications, web as well as database designing and is devoted to the optimization and usability of the code. He maintains Programming forum and is a C++ addict.

All articles By shabbir

Recent Articles

• Setting-Up a Relational Database in MySQL, Started by hurricanesoftwares in MySQL / PostGRESQL
• Replace Statement in MySQL, Started by pradeep in MySQL / PostGRESQL
• Why Prepare SQL Queries??, Started by pradeep in MySQL / PostGRESQL
• Database Transaction Auditing With MySQL and PostgreSQL Using Triggers, Started by pete_bisby in MySQL / PostGRESQL
• Foreign Keys in MySQL, Started by pradeep in MySQL / PostGRESQL

Similar Articles

• Basic BIOS password crack, Started by vishal sharma in Ethical hacking
• Steps To Secure Your MySQL Databases, Started by Mary in MySQL / PostGRESQL
• Vista vs Mac OS X, Started by Febian in Windows
• MySQL Storage Engines, Started by Janu in MySQL / PostGRESQL

I just happen to make my life worse when I forgot my MySQL password on my Vista PC. I tried Googling out for forgot password for Windows Vista but happen to find everything from XP to Linux but not Vista and after going through each of them including the Linux one's as well I happen to reset the password so thought I would share my experience on how to reset MySQL password on Vista.

• Log on to your system as Administrator.
• Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager:
  
  Start Menu -> Control Panel -> Administrative Tools -> Services
  
  Then find the MySQL service in the list, and stop it.
  
  If your server is not running as a service, you may need to use the Task Manager to force it to stop.
• Start the Command Prompt ( cmd.exe ) as an Administrator by Right clicking the short cut and selecting Run as Administrator.
  You will be prompted and allow everything.
• Now start the mysqld process with --skip-grant-tables option.
• Keep that window open and open a new command prompt and browse to the location of MySQL and start MySQL with -u root option. It will not ask for any password and now execute the following SQL.
  

  UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';

  Replace the ('password') with your password.
• Now execute

  FLUSH PRIVILEGES;

• Restart your PC and now it should allow you to access MySQL with your password

[pradeep]

Cool :-) It happened to me once, but I just reinstalled MySQL :P

[shabbir]

Originally Posted by pradeep

Cool :-) It happened to me once, but I just reinstalled MySQL :P

[darsh999]

Well my friend also facing the same situation but i have tried your technique too but the service manager is not opening in other servers !
So what should we do ?

[shabbir]

What do you mean by

Originally Posted by darsh999

service manager is not opening in other servers !

[verci]

i also reinstalled My SQL