Bug #55200 mysql-5.1.48-winx64 (/essential) install fails on Windows Server 2008 64 bit
Submitted: 12 Jul 2010 23:33 Modified: 7 Dec 2016 15:04
Reporter: Martin Jones Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:mysql-5.1.48 OS:Windows (Server 2008 r2 64 bit)
Assigned to: CPU Architecture:Any
Tags: 64bit Windows

[12 Jul 2010 23:33] Martin Jones
Description:
I have tried installing both the mysql-5.1.48-winx64 and mysql-essential-5.1.48-winx64 packages on Windows Server 2008 unsuccessfully.
The package seems to install but when it gets to the Server Instance Config Wizard hangs every time at the last step.
[Application hang]
The program MySQLInstanceConfig.exe version 1.0.16.0 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center control panel.
 Process ID: f84
 Start Time: 01cb221871ee4aaa
 Termination Time: 2
 Application Path: C:\Program Files\MySQL\MySQL Server 5.1\bin\MySQLInstanceConfig.exe
 Report Id: e4064d6f-8e0b-11df-9d17-b8ac6f11bfb1

Searching through the Event Viewer the only thing I can see that looks interesting is:  
Unknown/unsupported table type: INNODB  
&
Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

I have enabled tcp/ip (not enabled by default).

What am I missing?
Cheers
Marty

How to repeat:
Try installing either mysql-5.1.48-winx64 and mysql-essential-5.1.48-winx64 packages on Windows Server 2008 r2 64 bit OS.

Mine is a brand new server with only WinRar installed so far.
[13 Jul 2010 1:51] MySQL Verification Team
Thank you for the bug report. Could you please describe step by step the install process you did (options selected) also look for the my.ini file and attach it here if it exists. Thanks in advance.
[13 Jul 2010 8:57] Martin Jones
Hi Miguel
Before I start:
- I tried to get back to do a clean install but it never worked.
1) I used the Server Config Wizard to remove any instances.
2) I Used the control panel to remove MySql Server.
3) I deleted all folders (ie C:\Programs\MySql and D:\Msql Datafiles\ )
Everything appears to be removed (nothing in the Services manager) however when I try a fresh install I am still prompted to re-enter the root password (hmmmmm ... that got me thinking).

I repeated steps 1), 2) and 3) AND this time I manually typed in the folder directory C:\Users\All Users\ (this isn't visible by default) .. then I found another folder called MySql. After deleting THAT folder I have been able to reinstall MySql successfully.
Hooray :-)

NOW ... after installing MySql WorkBench 5.2 CE it breaks MySql :-(
I changed the default db path in Workbench to be D:\Msql Datafiles\
If I try and restart MySql server if fails with error 1067
So perhaps this is a Workbench issue?
*back to the drawing board*

-------------------------------------------------------------------
To answer your question:
MySql install.

Start installer
->Typical. 
--> Install to C:\Program Files\MySQL\MySQL Server 5.1\

Configure
->Detailed
-->Server
--->Multi
---->InnoDB tablespace D:\MySql DataFiles\
-----> Online Transaction Processing (OLTP)
------>Enable TCP/IP port 3306 (firewall not enabled) + Enable Strict.
------->Standard Char. Set (Latin1)
-------->Install as a Windows Service
---------> Enter password details. No anonymous and no root access from remote.

Hope that helps.

Cheers
Martin
[29 Sep 2010 11:16] Susanne Ebrecht
Your Workbench problem was a bug in Workbench that is already resolved in actual version.

Anyway, please try to install MySQL without installer and let us know if this will work fine.
[29 Oct 2010 23:00] Bugs System
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".
[7 Dec 2016 15:04] Yngve Svendsen
Posted by developer:
 
This relates to EOL (no longer supported) versions of MySQL Server. Furthermore, the old plain msi installers have been superseded by the MySQL Installer for Windows. Thus closing.