Bug #62181 MySQL Setup fails when configuring MySQL Server 5.5.15
Submitted: 16 Aug 2011 17:45 Modified: 4 Oct 2012 7:05
Reporter: Derek Bates Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:5.5.15 OS:Windows (XP Pro SP3 x32)
Assigned to: CPU Architecture:Any

[16 Aug 2011 17:45] Derek Bates
Description:
Whilst attempting to install MySQL 5.5 using mysql-installer-5.5.15.0.msi I get "mysql-server-5.5-win32-gpl:100 - Unable to configure service." reported in details. I've tried running the debug bit from CMD but I get this:-

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld --defaults-file=path_for_my_i
ni\my.ini --standalone --console
Could not open required defaults file: C:\Program Files\MySQL\MySQL Server 5.5\b
in\path_for_my_ini\my.ini
Fatal error in defaults handling. Program aborted

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld --defaults-file="C:\Documents
 and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\my.ini --standal
one --console
Could not open required defaults file: C:\Documents and Settings\All Users\Appli
cation Data\MySQL\MySQL Server 5.5\my.ini --standalone --console
Fatal error in defaults handling. Program aborted

Can you help me?

How to repeat:
Don't know. I've un-installed, restarted and re-installed and it repeats then.
[16 Aug 2011 17:50] Derek Bates
The install log from the MSI.

Attachment: bug-data-62181.rar (application/octet-stream, text), 62.80 KiB.

[16 Aug 2011 17:58] MySQL Verification Team
From a command prompt run as Administrator try:

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini" --standalone --console
[16 Aug 2011 18:40] Derek Bates
I followed your suggestion and got this:-

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\PendleSoft>cd..

C:\Documents and Settings>cd..

C:\>cd C:\Program Files\MySQL\MySQL Server 5.5\bin

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld --defaults-file="C:\Program F
iles\MySQL\MySQL Server 5.5\my.ini" --standalone --console
110816 19:38:50 [Note] Plugin 'FEDERATED' is disabled.
110816 19:38:50 InnoDB: The InnoDB memory heap is disabled
110816 19:38:50 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110816 19:38:50 InnoDB: Compressed tables use zlib 1.2.3
110816 19:38:50 InnoDB: Initializing buffer pool, size = 46.0M
110816 19:38:50 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 20971520 bytes
InnoDB: than specified in the .cnf file 0 24117248 bytes!
110816 19:38:51 [ERROR] Plugin 'InnoDB' init function returned error.
110816 19:38:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

110816 19:38:51 [ERROR] Unknown/unsupported storage engine: INNODB
110816 19:38:51 [ERROR] Aborting

110816 19:38:51 [Note] mysqld: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.5\bin>
[17 Aug 2011 8:14] Valeriy Kravchuk
OK, so this is the problem:

110816 19:38:50 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 20971520 bytes
InnoDB: than specified in the .cnf file 0 24117248 bytes!

Please, change innodb_log_file_size value in the "C:\Program Files\MySQL\MySQL Server 5.5\my.ini" file to match the real size:

innodb_log_file_size=20971520

and try to start server again.
[17 Sep 2011 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".
[21 Sep 2011 0:12] Nicholas McCants
I tried that solution and it is still giving me the same error
[14 Jun 2012 22:11] MySQL Verification Team
Are you tried Valeriy's suggestion?. Thanks.
[15 Jul 2012 1: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".
[4 Oct 2012 7:05] Marko Mäkelä
Duplicate of Bug#13494