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:
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:4.1.12 OS:Windows (Windows XP PRO SP2)
Assigned to: CPU Architecture:Any

[1 Jun 2005 8:40] yves jamoneau
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.
[1 Jun 2005 15:20] Jorge del Conde
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.


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 ?

[7 Jun 2005 7:04] Sheryl Mosbarger
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?
[7 Jun 2005 8:41] Sheryl Mosbarger
After reading bugs 7107, 7548, and 7702, I removed MySQL and then manually deleted all "MySQL...Datafiles" folders.  The install completes without error.
[5 Oct 2006 17:01] Rouslan Gueorguiev
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 removing and reinstalling MySQL fixed the problem.