Bug #62106 MySQL Configuration Wizard does not anticipate existing files...

• Submitted: 6 Aug 2011 10:56
• Modified: 16 Jul 2013 16:08
• Reporter: Dennis Dole
• Status: Closed
• Category: MySQL Server: Installing
• Severity: S2 (Serious)
• Version: 5.5.15/5.6.11
• OS: Windows (Vista 32-bits)
• CPU Architecture: Any
• Tags: Configuration Wizard, install, Uninstall Re-Install

[6 Aug 2011 10:56] Dennis Dole

Description:
MySQL Configuration Wizard does not anticipate existing files from previous MySQL install.
Existing files cause MySQL Configuration Wizard to fail on service start.
Workaround is for the user to manually delete the MySQL data in the ProgramData folder.

How to repeat:
1. Install MySQL with default settings & run Config Wizard.
2. Uninstall MySQL
3. RE-Install MySQL with default settings & run Config Wizard.

Expected Results:
- Install should complete successfully.
- Configuration Wizard should complete successfully.
- Uninstall should complete successfully.
- RE-Install should complete successfully.
- Configuration Wizard should complete successfully.

Actual Results:
- Install completes successfully.
- Configuration Wizard completes successfully.
- Uninstall completes successfully.
- RE-Install completes successfully.
- Configuration Wizard FAILS on "Start Service"

Suggested fix:
Either:
- Uninstall should COMPLETELY remove the MySQL ProgramData files and folders.
OR
- Configuration Wizard should delete/overwrite (or prompt to) existing files in the MySQL ProgramData folder.

[6 Aug 2011 10:57] Dennis Dole

This bug could apply to either the Config Wizard, or the Installer/Uninstaller.
(Depending on the resolution route taken.)

[8 Aug 2011 12:44] Valeriy Kravchuk

Please, list all steps you pass in Config. Wizard, and what options you choose/set there.

[9 Aug 2011 21:48] Dennis Dole

All wizard settings are left at -defaults- during both the initial install, and for the failing re-install (after successful uninstall).

The error occurs on this screen:
http://dev.mysql.com/doc/refman/5.5/en/mysql-config-wizard-confirmation.html
by "Start service" failing, (after "Prepare configuration" and "Write configuration file" both succeed).

(Issue was discovered after I uninstalled a successful standalone MySQL install in order to install xampp, from which I decided that a full package xampp install was not my best solution, so attempted to re-install the standalone MySQL.)

[9 Aug 2011 21:49] Dennis Dole

I've since confirmed multiple times that attempting a MySQL install after uninstall MySQL will repro the issue.

[7 May 2013 21:59] MySQL Verification Team

Start Service Failed

Attachment: start_service_failing.png (image/png, text), 102.66 KiB.

[7 May 2013 22:18] MySQL Verification Team

I was able to repeat installing with 5.6.11 Windows Installer.

[16 Jul 2013 16:08] Paul DuBois

Noted in 5.5.32 changelog.

MySQL Configuration Wizard did not anticipate existing files from a
previous MySQL install operation, causing it to fail starting the
MySQL service. (Workaround: Manually delete MySQL data in the
ProgramData folder.)