MySQL Bugs: #67337: unable to start the mysql-service

Bug #67337	unable to start the mysql-service
Submitted:	23 Oct 2012 8:51	Modified:	23 Oct 2012 12:53
Reporter:	Kai Neumann	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.5.27 CE	OS:	Windows (XP SP3 32bit)
Assigned to:		CPU Architecture:	Any
Tags:	domain, service, unable to start, win XP, workgroup

Description:
Hi there, 

as an update from MySQL 4.1.22 I installed MySQL 5.5.27 on our test system (Win XP SP3) 

After finishing with configuration the service is trying to start
but it comes back with a hint that the service was stopped again.

In the eventlog I can see that the server doesn't start because 
the "Logon Service" isn't started. 

And "Logon Service" can't start because the PC is in a workgroup and not in a domain.

How to repeat:
Install mysql on a WinXP SP3 32Bit system in a workgroup, not in a domain.
-> Starting of the service will fail.

Suggested fix:
Remove dependencies to "Logon Service".

edit : mysql v5.1.66 works fine.

Thank you for the bug report. Have you followed the Manual recommendations for upgrade? http://dev.mysql.com/doc/refman/5.5/en/upgrading.html . Anyway please open a command prompt, go to the bin install directory and execute the below command:

mysqld.exe --defaults-file=path_for_my.ini --standalone --console

print here the error message.

Hi,

seems that I used a not-quite-correct term:
I didn't upgrade the existing 4.1 server but I installed the 
5.5 server as a second mysql instance for upgrading 
our debug/test-system to mysql 5.5.

With the command 

"C:\Programme\MySQL\MySQL Server 5.5\bin\mysqld.exe" --defaults-file="C:\Dokumente und Einstellungen\All Users\Anwendungsdaten\MySQL\MySQL Server 5.5\my.ini" --standalone --console"

the server is starting correct.

I stopped it again and tried to start the service but the service start still fails.

(command line: "C:\Programme\MySQL\MySQL Server 5.5\bin\mysqld" --defaults-file="C:\Dokumente und Einstellungen\All Users\Anwendungsdaten\MySQL\MySQL Server 5.5\my.ini" MySQL55)

User account for the service is "NT-AUTORITÄT\NETZWERKDIENST" (in english "NT AUTHORITY\Network Service")

Thank you for the feedback. Try to change for Local System Account using the Control Panel also check if the image path is correct. Thanks.

I changed the service account to "Local System Account"
but it's still the same behavior.

Here are the two relevant system log entrys:

system log entry for the mysql service:

Ereignistyp:	Fehler
Ereignisquelle:	Service Control Manager
Ereigniskategorie:	Keine
Ereigniskennung:	7001
Datum:		23.10.2012
Zeit:		13:36:36
Benutzer:		Nicht zutreffend
Computer:	MYSQL-TEST
Beschreibung:
Der Dienst "MySQL55" ist vom Dienst "Anmeldedienst" abhängig, der aufgrund folgenden Fehlers nicht gestartet wurde: 
%%0

Weitere Informationen ber die Hilfe- und Supportdienste erhalten Sie unter http://go.microsoft.com/fwlink/events.asp.

previous system log entry for the netlogon service:

Ereignistyp:	Fehler
Ereignisquelle:	NETLOGON
Ereigniskategorie:	Keine
Ereigniskennung:	3095
Datum:		23.10.2012
Zeit:		14:17:47
Benutzer:		Nicht zutreffend
Computer:	MYSQL-TEST
Beschreibung:
Dieser Computer ist als Mitglied einer Arbeitsgruppe konfiguriert, nicht als Mitglied einer Domne. Der Anmeldedienst braucht bei dieser Konfiguration nicht gestartet zu sein.

Weitere Informationen ber die Hilfe- und Supportdienste erhalten Sie unter http://go.microsoft.com/fwlink/events.asp.

small supplement:
1. it's not the v5.5.27 - it's the v5.5.28
2. what do you mean with "check if the image path is correct" ?
3. don't be dizzied about the different timestamps of the system log entrys.
   They are indeed in the same second. I took the older one from a earlier try.

Update:

after changing the system account for the service from 
"NT AUTHORITY\Network Service" to "Local System Account"
nothing seemed to change. But now I restarted the 
computer and the service was started immediately at system start.

Perhaps it was only the wrong account, selected by the 5.5.28 installer.

Thank you for the feedback. I already verified that install bug please see my comment in bug: http://bugs.mysql.com/bug.php?id=67119 :

[10 Oct 0:48] Miguel Solorzano
Thank you for the feedback. I installed the msi package and what I found was an installer bug and not problems with IPV6 connection. The service only started when  I reboot the machine and changed to system local account and found that the shortcut for the command line was wrong with the my.ini path. Notice below the path for the server and for mysql.exe of my.ini:"