MySQL Bugs: #20381: The service could not be started Error:0 on XP

Bug #20381	The service could not be started Error:0 on XP
Submitted:	11 Jun 2006 17:53	Modified:	17 Jun 2006 14:57
Reporter:	Amit Kulkarni	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	mysql-essential-5.0.22-win32.msi	OS:	Windows (windows XP)
Assigned to:		CPU Architecture:	Any

Description:
Hi,

I am trying to install mysql5 on windows XP machine. I am receiving error as follows:
The service could not be started Error:0
I tried reinstalling 4 times but was not successful. I tried disabling all by firewalls and tried installing again, which failed.
I manually went and tried starting the mqsql service, but failed.

Can you please help in this regard.

Thanks and Regards,
Amit

How to repeat:
Try installing again on XP

Amit,

please show what

mysqld --console

prints when you start it from an MS-DOS prompt.

Regards,

Heikki

What i understand from your requirement is, i need to open a command prompt and type "mysqld --console". when i did that, following was the output:

C:\Documents and Settings\amit>mysqld --console
'mysqld' is not recognized as an internal or external command,
operable program or batch file.

I tried from statr menu->Mysql5.0->MySqlcommanlineclient, it asked for a password, I put the password which i had configured during the installation steps. The window exited.

PROBLEM :-((

>'mysqld' is not recognized as an internal or external command
you should add directory contains mysqld.exe into PATH variable or use absolute path to mysqld.exe

hi thanks for the reply.

I tried searching for the file mysqld.exe in the "C:\Program Files\MySQL\MySQL Server 5.0" folder where i have tried installing mysql. Instead i found following 2 files:
mysqld-nt.exe, mysqldump.exe

I had downloaded the standard installation from mysql site ( mysql-essential-5.0.22-win32.msi)...that rules out the possibility of wrong installation file..

Please, read carefully http://dev.mysql.com/doc/refman/5.0/en/windows-select-server.html about MySQL Server types.

Thanks for all the supprt.... i left pursuing mysql5.0...i have installed 4.2 version and is working fine....
Thanks again

Hi,everyone;

My name is Hiroshi TANAKA.
I write this comment from Japan.
I'm sorry that I cannot write English fluentry.

By the way,
I had the same trouble until just now.
And I resolved it now.

All I did do are the below:

1.I uninstalled MySQL.
2.I deleted "C:\Program Files\MySQL" folder
  because it was left even after I uninstalled MySQL.
3.I modified Environment value "Path"
  because ";\;" sentence was left after I uninstalled MySQL.

After I did the 3 action, I was able to reinstall MySQL
which version is latest version (MySQL Server 5.0).

Please try it!!
If you have the same trouble.

Thank You
Best Regards
Hiroshi TANAKA

I had the same problem, but it works properly by following Hiroshi's instruction
thx

Selecting only MyISAM storage engine solved my problem.
Hope this is helpful.

Hiroshi's fix didn't work for me.

I tried several times.

Finally, I re-installed using the Custom installation choice accepting all the defaults and the service started OK.

If you got this error:
"The service could not be started Error:0"

you need put in o windows path:
WinXP>My computer> Right click, properties>Advanced Setting>Enviroment Variable>
In system variable: NEW>Variable name: MYSQL Variable value: C:\Program File\MySQL\MySQL Server 5.0\bin> OK > OK

Dont need restart computer to work, that it.

"C:\Program Files\MySQL\MySQL Server 5.1\bin\mys
qld" --console
090331 16:29:03 [Warning] Changed limits: max_open_files: 2048  max_connections:
 800  table_cache: 619
InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 30408704 bytes!
090331 16:29:06 [ERROR] Plugin 'InnoDB' init function returned error.
090331 16:29:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

090331 16:29:06 [ERROR] Unknown/unsupported table type: INNODB
090331 16:29:06 [ERROR] Aborting

090331 16:29:06 [Warning] Forcing shutdown of 1 plugins
090331 16:29:06 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutd
own complete

I can install 5.0 but 5.1 hangs every time with Error:0 or trying to start the service for the first time (more common).  I ran mysqld --console and got this:

Plugin 'FEDERATED' is disabled.

and nothing else

Any ideas?  I have reinstalled many times and made sure the directories are deleted and the registry is cleared before I install again.  I have also tried downloading the installer multiple times.

When I stopped the service these errors came up on the console.

100125 16:27:38 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
100125 16:27:39 [ERROR] Plugin 'InnoDB' init function returned error.
100125 16:27:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

100125 16:27:39 [ERROR] Unknown/unsupported table type: INNODB
100125 16:27:39 [ERROR] Aborting

100125 16:27:39 [Note] mysqld: Shutdown complete

I finally got it to work by updating the environment path.  Ugh - what a crappy installer