MySQL Bugs: #10610: cant configure the mysql server instance

Bug #10610	cant configure the mysql server instance
Submitted:	12 May 2005 22:32	Modified:	13 Jun 2005 0:03
Reporter:	nadine ...	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:		OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any

Description:
When I install mysql-4.1.8-win it always end up with the following
screen :
**********************************************
MySQL Server Instance Configuration Wizard
MySQL Server Instance Configuration
Configure the MySQL Server 4.1 server instance.
Processing configuration...

/ Prepare configuration
/ Write configuration file (c:\Program ... \my.ini)
x Start service
  Apply Security settings

cannot create windows service for MySQL. Error:0
i dont know what to du, and how can i start using it
any help please?
thanks in advance
bye

How to repeat:
each time i install MySQL this message appears to me when i try to configure a new instance from the server

Do you have a firewall enabled ?. I am able for to install on XP without any
problems.

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".

I encounter the exact same problem every time I reconfigure my instance on Windows XP (don't ask why I reconfigured, I just tried it once and HAD to retry until I had a service running again). I am running Windows Firewall, so it may have something to do with that.

The fix I used was not exactly a fix at all, but I am only saying that because I still need to find out why it worked. All I did was select my last working configuration file, backed up as C:\Program Files\MySQL\MySQL Server 4.1\my 2005-06-28 1338.ini.bak.

Perhaps the answer lies in the specific config options, a fair assumption considering that choosing this specific config file fixed the problem. Alright to cut things short, here is the result of a line by line comparison of the working config file (file 1) and a broken config file (file 2):

File 1 is: C:\Program Files\MySQL\MySQL Server 4.1\my 2005-06-28 1338.ini
File 2 is: C:\Program Files\MySQL\MySQL Server 4.1\my.bak2

Processing:

File 1, Line 80:
<begin>
default-storage-engine=myisam
<end>
File 2, Line 80:
<begin>
default-storage-engine=INNODB
<end>

File 1, Line 97:
<begin>
query_cache_size=0
<end>
File 2, Line 97:
<begin>
query_cache_size=8M
<end>

File 1, Line 119:
<begin>
#(Unknown option:)thread_cache=8
<end>
File 2, Line 119:
<begin>
thread_cache=8
<end>

File 1, Line 151:
<begin>
read_rnd_buffer_size=256K
<end>
File 2, Line 151:
<begin>
read_rnd_buffer_size=185K
<end>

File 1, Line 157:
<begin>
sort_buffer_size=212K
<end>
File 2, Line 157:
<begin>
sort_buffer_size=139K
<end>

File 1, Line 161:
<begin>
innodb_data_home_dir="C:/MySQL InnoDB Datafiles/"
<end>
File 2, Line 161:
<begin>

<end>

6 lines were unequal, (maximum unequal lines before quit = 20)