MySQL Bugs: #36305: Windows Config Wizard prompts for uneeded, existing root pw on Server upgrade

Bug #36305	Windows Config Wizard prompts for uneeded, existing root pw on Server upgrade
Submitted:	23 Apr 2008 21:37	Modified:	20 May 2008 15:48
Reporter:	Patrick Crews	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.1, 6.0	OS:	Windows (XP 32 bit)
Assigned to:	Iggy Galarza	CPU Architecture:	Any
Tags:	.msi, configuration, install, password, root, windows

Description:
When installing 6.0 on a Windows machine with an existing 5.1 instance, the Instance Config Wizard prompts the user for the existing root password in order to set the new 6.0 root password.

Using the existing 5.1 pw causes the change in security settings portion of the configuration to fail.

The proper value for the current pw prompt is nothing (default root pw value). Doing this will result in a successful configuration.

I suspect this will occur for any upgrade / downgrade combination (5.0 on a 5.1 machine, 5.1 on a 5.0 machine, etc, etc) -- as long as the new installation uses version 1.0.12.0 of the Config Wizard.

This behavior was added as a fix for Bug#24215.

How to repeat:
Using a Windows machine:
1) Download the 5.1.24 .msi
2) Download the 6.0 .msi
3) Install and configure 5.1.24, setting the root password to something other than the default
4) Install and configure 6.0 -- at the security settings stage, you will see the existing root password prompt.
5) Try entering the 5.1.24 pw in this field and enter something else for 6.0's root pw.
6) Complete the configuration and it will fail
7) Start the 6.0 mysql client and just hit <Enter> when prompted for a password -- you will see that the proper value should have been '' (nothing)

Suggested fix:
Have the .msi differentiate between different versions of the server.

Since the .msi isn't for upgrading between major versions 5.0 -> 5.1, the existing pw prompt should only come up if that is what you are doing (5.1.23 -> 5.1.24, etc).

As a workaround - remember that the root pw will be '' on a new installation of a version of the server, even if prompted.  (ie installing 6.0 on a machine with 5.1 running).

Ok to push.

Verified that the user isn't prompted for an existing password when configuring a fresh install of a server (ex:  5.1 install on a machine with 5.0).

Install and config worked without incident.

Noted in 5.1.25, 6.0.6 changelogs.

When updating an existing instance (for example, from MySQL 5.0 to
5.1, or 5.1 to 6.0), the Instance Configuration Wizard unnecessarily
prompted for a root password when there was an existing root 
password.