Cannot create windows service for MySQL

[cearlp]

When trying to install MySQL on Windows 7 (Home Premium) I get through most of the install procedure but always come up with the error stated in the title appended with Error 0.
Any suggestions would be appreciated.

 

[fluke78]

When trying to install MySQL on Windows 7 (Home Premium) I get through most of the install procedure but always come up with the error stated in the title appended with Error 0.
Any suggestions would be appreciated.

Error 0 is often ERROR_SUCESS ( == No error )
Perhaps the service is already existing, that's why you get an error 0 (ok), but message says it can't create it since it's already exists...

Run "mmc services.msc" and check if the mysql service is in the list....

 

[cearlp]

There is a service mysql listed as being Start up Type Automatic but it's blank under Status.
I have stopped and deleted the service before and it appears this is as far as it gets in the install. That is, the mysql service gets partially created, since it appears in the list again after the install, but but it never gets completed, and started.

 

[fluke78]

There is a service mysql listed as being Start up Type Automatic but it's blank under Status.
I have stopped and deleted the service before and it appears this is as far as it gets in the install. That is, the mysql service gets partially created, since it appears in the list again after the install, but but it never gets completed, and started.

What happens if you try to start the service manually then?

 

[cearlp]

I can't find a mysql_start script. I manually run mysql_installservice.bat and get the following.
Installing MySQL as an Service
The system cannot find the file specified.
Install/Remove of the Service Denied!
Try to start the MySQL deamon as service ...
Press any key to continue . . .
System error 5 has occurred
Access is denied.
Looking at the installservice.bat file shows that there is no my.cfg or my.ini file.

 

[fluke78]

I can't find a mysql_start script. I manually run mysql_installservice.bat and get the following.
Installing MySQL as an Service
The system cannot find the file specified.
Install/Remove of the Service Denied!
Try to start the MySQL deamon as service ...
Press any key to continue . . .
System error 5 has occurred
Access is denied.
Looking at the installservice.bat file shows that there is no my.cfg or my.ini file.

Ahh..

If you're running a script which needs admin privileges (and it DOES if it handles services etc), you must start the command prompt you're using As Administrator (right click on Command Prompt, and select "Run as Administrator"

That might help.

 

[cearlp]

Yeh, that does make a difference, running the installservice now gives me a new error after starting the service. It fails to start with a System error 1067

 

[fluke78]

Yeh, that does make a difference, running the installservice now gives me a new error after starting the service. It fails to start with a System error 1067

A quick search with google on your error message gave me this: http://stackoverflow.com/questions/4577356/system-error-1067-has-occurred

 

[cearlp]

I will try to follow one or more of the fixes posted ,
Thanks, I will post later what happened.