Bug #76317 MySQL services stop automatically
Submitted: 13 Mar 2015 14:14 Modified: 23 Apr 2015 15:34
Reporter: Roushan Singh Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:MySQL 5.5.42 OS:Windows ( 64bit)
Assigned to: CPU Architecture:Any
Tags: MySQL Service getting stop automatically after few seconds.

[13 Mar 2015 14:14] Roushan Singh 
Description:
Name of the application that generated the error : mysqld.exe , Version : 5.5.42.0 , timestamp : 0x54ac4a9a
Name of the module that generated the error : mysqld.exe , Version : 5.5.42.0 , timestamp : 0x54ac4a9a
Exception code : 0x80000003
Offset error 0x000000000021fac2
ID process that generated the error : 0x1180
Start time of the application that generated the error : 0x01d05d921cb677ec
Path to the application that generated the error : C : \ Program Files \ MySQL \ MySQL Server 5.5 \ bin \ mysqld.exe
Path of the module that generated the error : C : \ Program Files \ MySQL \ MySQL Server 5.5 \ bin \ mysqld.exe
ID reporting : 5b70159c - c985-11e4 - A093 - d485640519cd

How to repeat:
I actually installed MYSQL Server 5.5.42 on the system but when tries to connect through workbench or command prompt. It showing me connection error.
[13 Mar 2015 14:23] MySQL Verification Team 
Please attach here the err log file generally called real_host_name_machine.err and located on data directory. Thanks.
[16 Mar 2015 12:34] Roushan Singh 
I tried to find the file in the MySQL installed directory i.e "C:\Program Files\MySQL\MySQL Server 5.5" but not able to locate it.
[16 Mar 2015 16:50] MySQL Verification Team 
The log err file generally is located in path like:

C:\ProgramData\MySQL\MySQL Server 5.6\data

change the 5.6 version for yours.
[17 Mar 2015 8:43] Roushan Singh 
I have search the whole C: drive and path you have mention but didn't find any such file on the system.
[23 Mar 2015 15:34] MySQL Verification Team 
Be sure your MySQL Server is stopped check task manager or local service for.
Then open a command prompt with administrator privileges and perform the below command (change mysql561 for your actual service name):
C:\dbs>sc qc mysql561
[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: mysql561
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL561
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : MySQL561
        DEPENDENCIES       :
        SERVICE_START_NAME : NT AUTHORITY\NetworkService

Print here the output.
[24 Apr 2015 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[16 Feb 2023 9:03] Reshmi Laijulal 
I am also facing the same issue. MySQL is closing automatically in the services. Any one please suggest a solution for this? It is creating a lot of iisue.