MySQL Bugs: #11012: Mysql error number 2003 can't connect to mysql server on XXX(10061)

Bug #11012	Mysql error number 2003 can't connect to mysql server on XXX(10061)
Submitted:	1 Jun 2005 8:40	Modified:	1 Jun 2005 15:20
Reporter:	yves jamoneau	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	4.1.12	OS:	Windows (Windows XP PRO SP2)
Assigned to:		CPU Architecture:	Any

Description:
I have downloaded mysql-4.1.12-win32.zip (same problem with version 4.1.11).
I unzip that file to obtain setup.exe, which I execute.
At the end of the installation process, the third point (start server) gets a red check and I get the message box detailed above in the synopsis. If I install mysqladmin, and try to start the server, I get: "cannot create windows service for mysql. error:0"
I have repeated the process with or without choosing "install mysql as a service", I have tried to desactivate my anti-virus, to stop my local instance of SQLServer, etc...Nothing does.
I must mention that I have somewhere on my system an earlier version of mysql, packaged with EasyPHP, but it is never activated.

How to repeat:
every time I launch the install.

I was unable to reproduce these results with 4.1.12:

After running setup (and choosing typical config), I did the following:

C:\WINDOWS>mysql -uroot -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.1.12a-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Everything worked out as expected.

Is there any other information or environment specific settings that you can give us, in order for us to reproduce this bug ?

Thanks

This is my first attempt to install MySQL.  I installed mysql-essential-4.1.11-win32.msi using all defaults.  As with bug 11012, at the end of the MySQL Server Instance Configuration Wizard 1.0.4, when I "press" Execute, the first step (Prepare configuration) and the second step (Write configuration file) complete without error, however the third step (Start service) gets a red check and a message "Could not start the service MySQL.Error:0"

From Control Panel > Administrative Tools > Services, I find MySQL (not started) with a Startup Type of Automatic and Log On As set to Local System.  From the Services Window, when I select MySQL and press start, I get an error "Could not start the MySQL service on Local Computer.  Error 1067: The process terminated unexpectedly".  From the Services windown, I checked the properties of MySQL (right click and Properties) - what should I expect under the Log On tab?  Any log files I can look at?

After reading bugs 7107, 7548, and 7702, I removed MySQL and then manually deleted all "MySQL...Datafiles" folders.  The install completes without error.

I have encountered a similar problem in Windows XP Pro. 
After starting up in the morning (MySQL is configured for autostart) I could not connect neither from the command line, nor from MySQL Administrator, nor see the server from VS.NET environment.
After scratching my head for a while (nothing has changed on my machine since last night, right!?)and looking at posts for error 2003 on server 127.0.0.1(10061) removing and reinstalling MySQL fixed the problem.