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:
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:5.1, 6.0 OS:Microsoft Windows (XP 32 bit)
Assigned to: Iggy Galarza CPU Architecture:Any
Tags: .msi, configuration, install, password, root, windows
Triage: D2 (Serious)

[23 Apr 2008 21:37] Patrick Crews
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 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).
[23 Apr 2008 21:40] Patrick Crews
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).
[6 May 2008 20:36] Patrick Crews
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.
[20 May 2008 15:48] Paul Dubois
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