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: | |
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
[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.