MySQL Bugs: #32086: Unable to configure MySQL 5.0 in Windows XP

Bug #32086	Unable to configure MySQL 5.0 in Windows XP - Throws an error (code:1045)
Submitted:	4 Nov 2007 9:26	Modified:	6 Aug 2008 6:35
Reporter:	Vaibhav Gumashta	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	5.0	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Hi,

I have tried for hours and have tried every possible combination, but have been unable to configure MySQL 5.0(Community Release) on my machine. I keep getting an error (code:1045) at the last step where we need to specify the password for the root user.

How to repeat:
Try configuring on any machine - any configuration!

Suggested fix:
No idea!

Thank you for the report.

Do you have previous version of MySQL already installed?

Please indicate accurate version of MySQL server you trying to install.

Also indicate if user you run configuration wizard as has administrative privileges.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Okie, I should have posted this long back.

Actually on windows the problem is that if you are reinstalling MySQL then it retains certain configuration info from the last install. Also, at times the registry files are not deleted on their own.

In case you face such a problem, try:
1.) Uninstalling MySQL
2.) Delete registry keys for MySQL
3.) Go to: C:\Program Files and delete the MySQL folder entirely from there (make sure you copy the DB Backup files to some other location if they're there)

I have installed MySQL in a few machines after that, and by following either of the three steps I was able to get around any issues that I faced

I guess team MySQL can look at improving the uninstall / reinstall process by cleaning the registry and removing all the MySQL files (except backup) from the hard drive. Obviously a prompt to copy the backups should be given before the process starts 

Cheers!
--Vaibhav

Thank you for the feedback.

Error 1045 (Access denied) is expected if you upgrade MySQL installation: MySQL keeps privileges in system tables, so it is by design to keep data directory untouched when upgrade.