Mysql Server Instance Configuration Wizard Start Service Error 0
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: Cannot Create Windows Service for MySQL. Error:0 New Topic Advanced Search Re: Cannot Create Windows Service for MySQL. Error:0 - VARIED SOLUTIONS Posted by: Jean-Paul Bourdais () Date: February 08, 2009 09:35AM Long post I know. I spent literally _hours_ on this so just wanted to share some of my observations to save you some time. Incidentally Win XP Service Pack 2 installing MySQL 5.1.31 MSI. Seems like the non msi MySQL 4.1 installer doesn't have this problem. MY SOLUTION (Take UNLOADS and BACKUPS of data files/dirs if you need to. This is a full re-install) My solution was to get rid of all the profile application data. So ensure that you - uninstall the instance (including server) using instance configuration wizard, (in C:\Program Files\MySQL\My SQL Server 5.1\bin\MySQLInstanceConfig.exe), choosing remove. - now remove MySQL via Control Panel->add/remove programs, may need to F5 refresh list if not there. - make sure MySQL dir in C:\Program Files is now deleted in its entirety. There may be old Data files lying around. - *most importantly*, make sure that any MySQL dir in the following dirs are deleted. Mine weren't hidden but worth checking that too: = C:\Documents and Settings\All Users\Application Data = C:\Documents and Settings\
Email Updates: Status: Duplicate Impact on me: None Category:MySQL Server: Config Wizard Severity:S2 (Serious) Version:5.1 OS:Microsoft Windows (Vista) Assigned to: Tags: bug View Add Comment Files Developer Edit Submission View Progress Log Contributions [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 http://forums.mysql.com/read.php?11,19373,246717 ,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 https://bugs.mysql.com/bug.php?id=43248 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] Valerii 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 "Th
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business http://stackoverflow.com/questions/4132151/could-not-start-the-service-mysql-error-0 Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up could not start the service MySQL.error 0 up vote 1 down vote favorite I am getting the following error when I try to configure mysql server MySQL instance, could any one help out to resolve this error. I am using Windows XP SP2. mysql windows-xp-sp2 share|improve this question edited Jan 21 '12 at 4:29 studiohack 191415 asked Nov 9 '10 at 9:30 mahesh 1,0241050103 Do you have any more info? Are you setting up a new instance? On localhost or a remote computer? Port? etc etc –simendsjo Nov 9 '10 at 9:31 1 Please when asking a system question, mysql server instance always add which operating system you're on –Pekka 웃 Nov 9 '10 at 9:32 add a comment| 2 Answers 2 active oldest votes up vote 5 down vote accepted If you reinstall or upgrade MySQL without first stopping and removing the existing MySQL service and install MySQL using the MySQL Configuration Wizard, you may see this error: Error: Cannot create Windows service for MySql. Error: 0 This occurs when the Configuration Wizard tries to install the service and finds an existing service with the same name. One solution to this problem is to choose a service name other than mysql when using the configuration wizard. This enables the new service to be installed correctly, but leaves the outdated service in place. Although this is harmless, it is best to remove old services that are no longer in use. To permanently remove the old mysql service, execute the following command as a user with administrative privileges, on the command-line: shell> sc delete mysql [SC] DeleteService SUCCESS If the sc utility is not available for your version of Windows, download the delsrv utility from http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/delsrv-o.asp and use the delsrv mysql syntax. -- http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooting.html share|improve this answer answered Nov 14 '10 at 0:32 ajreal 36.7k85899 add a comment| up vote 1 down vote Usually when the service doesn't manage to start, there will be more detailed informat