MySQL Bugs: #27796: The service could not be started. Error: 0

Bug #27796	The service could not be started. Error: 0
Submitted:	12 Apr 2007 22:33	Modified:	16 Apr 2007 13:06
Reporter:	Manoj Sharma	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	5.0.37	OS:	Windows (XP Pro (SP 2))
Assigned to:		CPU Architecture:	Any
Tags:	Error:0, installation, MySQL 5.0.37, Service could not be started, Windows Installation

Description:
Hi.  Just downloaded the latest version of MySql 5.0.37 for Windows (mysql-5.0.37-win32.zip).  On running the SETUP.EXE, the installation program fails with the error:
   "The service could not be started. Error: 0".

Tried following the steps as documented over here and in other places, but it still does not work.  

But, when I tried running the following commands from the command prompt (as explained in the my.ini file), there was absolutely no problem:

1. mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"

2. mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"

3. net start MySQLXY

However, when I went to the Services section on My Computer, I found that MySQL and MySQLXY services, both not running at all.  Tried starting them too, but this too did not solve the problem.

Can anyone help me please?

Thanks in advance,

MANOJ KUMAR SHARMA.

How to repeat:
Download the mysql-5.0.37-win32.zip file, and install the same on a Windows XP Professional machine, running with SQL Server 2005 and Visual Studio .NET 2005.

Thank you for the bug report. Could you please open a DOS prompt and
go to the MySQL bin\ directory and issue the below command:

mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" --standalone --console

and paste here the messages/errors printed. Thanks in advance.

Hi Miguel

Thanks for contacting me back.  

I have resolved my problem on my own.  I first of all used the configuration tool to remove the database.  Then, went to add/remove programs and removed mysql.  After which I restarted my computer.  Then went to the  C:\Program Files\MySQL\MySQL Server 5.0 folder and deleted it.  I also deleted the parent folder too. After which I went to the folder where I had downloaded your installation files, and deleted the same.

Next I rebooted my computer once again, so that all traces or references would be cleared.  And then I redownloaded the file from your website.  Installed.  And now, it seems to be working just fine.  I have downloaded TOAD for MySQL.  And it works perfectly.

Thanks for all the help anyways.

Regards,

MANOJ KUMAR SHARMA.

Thank you for the feedback.

Hey Miguel... I am a cmplete neewbie to even be able to use command prompt proberly... I downloaded MySQL 5.1, original upong "executing" to start mysql, I was getting another error... I did some reasearch and now that errors fixed.

Now I get...
"The service  could not be started. error: 0"

I tried opening the command prompt, and it asks for a passoword... no matter what password I put in, the CMD closes!
Help is appreciated thanks!

@ jgdfskljkl jkjl,

Yes there are bug reported and verified about that error message, in some case that message is false actually the service was installed and started and for some timeout issue the installed does that. Verify if it is your case too, just go to the start menu (while the installer shows that message ) look for the mysql client and start it, if you are able to login then just click cancel in the installer screen.

Thanks to MANOJ KUMAR SHARMA

your solution works perfectly, But TOAD is not required.

Asanka.

I have had same problem, server service would not start after configuration. My problem was resolved when I opened my.ini which is newly stored in UTF-8 encoding and saved it in ANSI encoding. After that server service started without problem. So MySQL Server Instance Config Wizard stoes this file in UTF-8 encoding and MySQL server service try to read it in ANSI encoding. Should be easy to resolve.

My Sql Download version 6.0 for windows xp and has an error The service set not could be started. Error: 0
I can do

And in fact I have seven windows installations steps I of this database to work at my university who can help me in Spanish you'll be grateful My Sql Download version 6.0 for windows xp and has an error The service set not could be started . Error: 0
I can do

thanks Mr. Miguel Solorzano
I was facing the problem as whenever i use to restart my pc i have to install every time mysql because my localhost page was not working with asp pages and after your suggesstion to this post i was able to rectify the erro and its working fine. Thanks once again.