Bug #43248 Cannot Create Windows Service for MySQL5.0.Error:0
Submitted: 27 Feb 2009 5:37 Modified: 30 Mar 2009 18:49
Reporter: Jyothsna Panchagnula Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Config Wizard Severity:S2 (Serious)
Version:5.1 OS:Windows (Vista)
Assigned to: CPU Architecture:Any
Tags: bug

[27 Feb 2009 5:37] Jyothsna Panchagnula
Description:
This is what I see when I trying to loginto the mysql.

I uninstalled mysql server 5.1in Windows vista laptop using ControlPanel-->Uninstall Programs and I installed it again. 
When I was trying to configure for Server instance ,during the configuration I see an error saying that"Cannot Create Windows Service for MySQL5.0.Error:0:".
When I tried loggin through command prompt this is what I saw

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

Please help me out what needs to be done.

How to repeat:
follow the same thing as above
[27 Feb 2009 7:01] Valeriy Kravchuk
Thank you for the problem report. What exact version, 5.1.x, are you trying to install? Please, upload also the results of

sc query type= service

command from cmd.exe (as private file, if you want).
[27 Feb 2009 12:39] Jyothsna Panchagnula
I am trying to install MySQL5.1 in my windows vista laptop. 
I want to configure the Server Instance withthe help of MySQL Instance Configuration Wizard as follows:-

1)Double Click on MySQLInstanceConfigurationWizard
2)Selected Detailed Configuration Type
3)Selected Developer machine
4)Selected Multifunctional Database
5)Clicked on Next for INNO DB
6) Selected Manual Setting
7)Enabled onTCP/IP Networking
8)Enable Strict Mode
9)Enable Standard Character SEt
10)Selected for Installs as Windows Service
11) Selected for Modify Security Settings
12) Gave the user login credentials
13) Clicked on next
14) I see an error saying that "The Service couldnot be started"

Pleae let me know how can I get this up and running
[28 Feb 2009 17:07] Sveta Smirnova
Thank you for the feedback.

Please start cmd.exe and provide output of command `sc query type= service`.

Also, please, provide your MySQL server error log file. You will find it in the MySQL data directory.
[22 Mar 2009 18:00] test test2
i have the same problem as Jyothsna Panchagnula but i runing on XP

i got out from writing in comand promot "sc query type= service"

[SC] EnumQueryServicesStatus:OpenService Failed 1060:

this is what is in the error att the same time i uinstalled/reinstalled mysql 5.1.31

[Sun Mar 22 19:24:36 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sun Mar 22 19:24:36 2009] [notice] Child 656: Exit event signaled. Child process is ending.
[Sun Mar 22 19:24:37 2009] [notice] Child 656: Released the start mutex
[Sun Mar 22 19:24:38 2009] [notice] Child 656: All worker threads have exited.
[Sun Mar 22 19:24:38 2009] [notice] Child 656: Child process is exiting
[Sun Mar 22 19:24:38 2009] [notice] Parent: Child process exited successfully.
[Sun Mar 22 19:34:39 2009] [notice] Apache/2.2.11 (Win32) PHP/5.2.8 configured -- resuming normal operations
[Sun Mar 22 19:34:39 2009] [notice] Server built: Dec 10 2008 00:10:06
[Sun Mar 22 19:34:39 2009] [notice] Parent: Created child process 1012
[Sun Mar 22 19:34:40 2009] [notice] Child 1012: Child process is running
[Sun Mar 22 19:34:40 2009] [notice] Child 1012: Acquired the start mutex.
[Sun Mar 22 19:34:40 2009] [notice] Child 1012: Starting 64 worker threads.
[Sun Mar 22 19:34:40 2009] [notice] Child 1012: Starting thread to listen on port 80.

Reason why i uinstalled mysql was that that the apache server crasht becuse php+mysql connection didin't work

Sorry for my bad english
[22 Mar 2009 18:01] test test2
i have the same problem as Jyothsna Panchagnula but i runing on XP

i got out from writing in comand promot "sc query type= service"

[SC] EnumQueryServicesStatus:OpenService Failed 1060:

this is what is in the error att the same time i uinstalled/reinstalled mysql 5.1.31

[Sun Mar 22 19:24:36 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sun Mar 22 19:24:36 2009] [notice] Child 656: Exit event signaled. Child process is ending.
[Sun Mar 22 19:24:37 2009] [notice] Child 656: Released the start mutex
[Sun Mar 22 19:24:38 2009] [notice] Child 656: All worker threads have exited.
[Sun Mar 22 19:24:38 2009] [notice] Child 656: Child process is exiting
[Sun Mar 22 19:24:38 2009] [notice] Parent: Child process exited successfully.
[Sun Mar 22 19:34:39 2009] [notice] Apache/2.2.11 (Win32) PHP/5.2.8 configured -- resuming normal operations
[Sun Mar 22 19:34:39 2009] [notice] Server built: Dec 10 2008 00:10:06
[Sun Mar 22 19:34:39 2009] [notice] Parent: Created child process 1012
[Sun Mar 22 19:34:40 2009] [notice] Child 1012: Child process is running
[Sun Mar 22 19:34:40 2009] [notice] Child 1012: Acquired the start mutex.
[Sun Mar 22 19:34:40 2009] [notice] Child 1012: Starting 64 worker threads.
[Sun Mar 22 19:34:40 2009] [notice] Child 1012: Starting thread to listen on port 80.

Reason why i uinstalled mysql was that that the apache server crasht becuse php+mysql connection didin't work

Sorry for my bad englis
[24 Mar 2009 20:11] Samba Siva Rao Kolusu
Hi,
   I too faced a similar problem when I uninstalled MySQL 5.1.30 and tried to install 5.1.32.
   I even tried removing the MySQL service using sc delete MySQL and rebooted the machine but still MySQL Service could not be created by MySQL Instance Config Wizard. 

   But luckily, I went passed this error by running MySQL Instance Config Wizard a couple of times when it showed  Remove  Service option instead of Detailed or Standard configuration option. I removed the existing service and then run the same wizard to freshly create a new service with the same name.

   I think the core of the problem lies with MySQL uninstaller because after uninstalling and installing again,either the same version or a older or newer version -- doesn't matter,  the instance config wizard is asking for current password , new password and confirm password.I guess,this is where the whole problem lies. 

I even tried deleting the MySQL folder under All Users/Application Data and My User/Application Data. But still the instance information is saved somewhere even after uninstallation. When the uninstaler removes the instance information either from backup files or from the registry, then I'm pretty much confident that this problem will be fixed.

Regards,
Samba
[28 Mar 2009 4:26] Johnny C.L.
SAme Problem with 5.0.77 64bit
we tryed 32bit

we try on Windows 2003 and 2008

same Issue
[28 Mar 2009 4:29] Johnny C.L.
Also i want to add that the Service is Created:

SERVICE_NAME: MySQL5
DISPLAY_NAME: MySQL5
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 4  RUNNING
                                (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0
[30 Mar 2009 18:49] MySQL Verification Team
Related to the bug: http://bugs.mysql.com/bug.php?id=43374.
[6 May 2009 22:02] RJ Nox
I've discovered a solution to this one. Open up services on your server/pc and restart the MySQL service. It will disappear from the list then try installing and starting the service again and it works!
[7 Jul 2009 18:14] Chris Petalas
After searching everywhere without hope and get crazy finally i found the solution.
1) First, uninstall MySQL server if is installed.
2) Close any Antivirus - Firewall application you have.
3) Make sure you have enabled Windows firewall and give exception to MySQL on port 3306. This is important, so make sure you do that.
4) Install the Server.
Hopefully you did it...

For some reason all most, every Antivirus i test cut's Configuration attempt to open the port 3306.
[16 Sep 2009 19:06] Olivier de Sylva
Having the same issue on a Windows 7.

Run MySQL Command Line Client, it request for the password, pressing just enter it gives this error message:
ERROR 2003 <HY000>: Can't connect to MySQL server on 'localhost' <10061>
[16 Sep 2009 19:56] Olivier de Sylva
It was a re-installation of MySQL to a new location that led to this problem.

This helped me:
http://forums.mysql.com/read.php?11,178571,178920#msg-178920

You know you fixed the problem when on the MySQL Server 5.1 - Setup Wizard "Ready to Modify the Program", Current settings show the Destination folder and Data Folder like you needed.

You know you fixed the problem when on the MySQL Server Instance Configuration Wizard "Modify Security Settings" this only ask for a New Root Password and not te Current Root Password.
[16 Sep 2009 19:56] Olivier de Sylva
It was a re-installation of MySQL to a new location that led to this problem.

This helped me:
http://forums.mysql.com/read.php?11,178571,178920#msg-178920

You know you fixed the problem when on the MySQL Server 5.1 - Setup Wizard "Ready to Modify the Program", Current settings show the Destination folder and Data Folder like you needed.

You know you fixed the problem when on the MySQL Server Instance Configuration Wizard "Modify Security Settings" this only ask for a New Root Password and not the Current Root Password.
[16 Sep 2009 19:57] Olivier de Sylva
It was a re-installation of MySQL to a new location that led to this problem.

This helped me:
http://forums.mysql.com/read.php?11,178571,178920#msg-178920

You know you fixed the problem when on the MySQL Server 5.1 - Setup Wizard "Ready to Modify the Program", Current settings show the Destination folder and Data Folder like you needed.

You know you fixed the problem when on the MySQL Server Instance Configuration Wizard "Modify Security Settings" this only ask for a New Root Password and not the Current Root Password.