Error: MySQL shutdown unexpectedly.

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Error: MySQL shutdown unexpectedly.

Postby 3-4-SAD » 02. August 2013 17:09

It's really frustrating. Nothing I do can make MySQL to work. Furthermore, all the check boxes at the left side in control panel are grey and nothing happens when I click them. I believe there are some serious bugs going on...
3-4-SAD
 
Posts: 7
Joined: 30. July 2013 09:56
XAMPP Version: 5.5.19
Operating System: win 7

Re: Error: MySQL shutdown unexpectedly.

Postby Altrea » 02. August 2013 20:04

Hi 3-4-SAD,

It is really difficult (and frustrating too) to provide support in a thread where multiple users try to report unsolved issues.
All issues can be different even the effect seems to be the same.
None of the error reports is detailed enough.

So if you really want to get help please open a new thread and report your issue as detailed as possible.
absolutely neccessary informations are:
  • your OS version (win 7 is NOT enough here. Windows 7 Embedded Standard 32Bit is very much different to Windows 7 Enterprise 64Bit)
  • your XAMPP version (not only the version number, but also the type (full|lite|portable, exe|zip|7z)
  • informations about the actions you did to "install" XAMPP (especially installation path, executed files)
  • informations about changes in the config files if any done
  • actions done to produce/reproduce the issue
  • full contents of your XAMPP control panel log window
  • relevant contents of the specific log files (related to MySQL especially the entries since start attempt in the mysql_error.log)

after knowing all of this information maybe more information are needed but that are the very basic ones needed for nearly every issue.
I have not seeing any of that information from you. And saying you have the same issue is worthless because you simply can't estimate that.

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6697
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: Error: MySQL shutdown unexpectedly.

Postby 3-4-SAD » 05. August 2013 09:50

Altrea, You're absolutely right. I apologize for my unclear comment.
Here it goes everything you have sprecified:

• your OS version (win 7 is NOT enough here. Windows 7 Embedded Standard 32Bit is very much different to Windows 7 Enterprise 64Bit)
My system is win 7 pro 64

• your XAMPP version (not only the version number, but also the type (full|lite|portable, exe|zip|7z)
xampp-win32-1.8.3-0-VC11

• informations about the actions you did to "install" XAMPP (especially installation path, executed files)
I've executed the xampp-win32-1.8.3-0-VC11-installer.exe directly to C:\xampp

• informations about changes in the config files if any done
Haven't touch anything

• actions done to produce/reproduce the issue
After the install everything worked fine. After the machine reboot, I can't start MySQL service.
If I uninstall xampp and reinstall it again MySQL works, but only up to the next system reboot.

• full contents of your XAMPP control panel log window
10:40:10 [main] Initializing Control Panel
10:40:10 [main] Windows Version: Windows 7 Professional SP1 64-bit
10:40:10 [main] XAMPP Version: 1.8.3
10:40:10 [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
10:40:10 [main] You are not running with administrator rights! This will work for
10:40:10 [main] most application stuff but whenever you do something with services
10:40:10 [main] there will be a security dialogue or things will break! So think
10:40:10 [main] about running this application with administrator rights!
10:40:10 [main] XAMPP Installation Directory: "c:\xampp\"
10:40:10 [main] Checking for prerequisites
10:40:11 [main] All prerequisites found
10:40:11 [main] Initializing Modules
10:40:11 [Apache] Initializing module...
10:40:11 [Apache] Checking for module existence...
10:40:11 [Apache] Checking for required tools...
10:40:11 [Apache] Checking for service (name="Apache2.4"): Service not installed
10:40:11 [Apache] Service Path: Service Not Installed
10:40:11 [Apache] Checking default ports...
10:40:11 [mysql] Initializing module...
10:40:11 [mysql] Checking for module existence...
10:40:11 [mysql] Checking for required tools...
10:40:11 [mysql] Checking for service (name="mysql"): Service not installed
10:40:11 [mysql] Service Path: Service Not Installed
10:40:11 [mysql] Checking default ports...
10:40:11 [filezilla] Initializing module...
10:40:11 [filezilla] Checking for module existence...
10:40:11 [filezilla] Checking for required tools...
10:40:11 [filezilla] Checking for service (name="FileZillaServer"): Service not installed
10:40:11 [filezilla] Service Path: Service Not Installed
10:40:11 [filezilla] Checking default ports...
10:40:11 [mercury] Initializing module...
10:40:11 [mercury] Checking for module existence...
10:40:11 [mercury] Checking for required tools...
10:40:11 [mercury] Checking default ports...
10:40:11 [Tomcat] Initializing module...
10:40:11 [Tomcat] Checking for module existence...
10:40:11 [Tomcat] Checking for required tools...
10:40:11 [Tomcat] Checking for service (name="Tomcat7"): Service not installed
10:40:11 [Tomcat] Service Path: Service Not Installed
10:40:11 [Tomcat] Checking default ports...
10:40:11 [main] Starting Check-Timer
10:40:11 [main] Control Panel Ready
10:40:23 [Apache] Checking default ports...
10:40:23 [Apache] Attempting to start Apache app...
10:40:23 [Apache] Executing "c:\xampp\apache\bin\httpd.exe"
10:40:23 [Apache] Return code: 0
10:40:23 [Apache] Status change detected: running
10:49:43 [mysql] Checking default ports...
10:49:43 [mysql] Attempting to start MySQL app...
10:49:43 [mysql] Executing ""c:\xampp\mysql\bin\mysqld.exe" --defaults-file="c:\xampp\mysql\bin\my.ini" --standalone"
10:49:43 [mysql] Return code: 0
10:49:43 [mysql] Status change detected: running
10:49:45 [mysql] Status change detected: stopped
10:49:45 [mysql] Error: MySQL shutdown unexpectedly.
10:49:45 [mysql] This may be due to a blocked port, missing dependencies,
10:49:45 [mysql] improper privileges, a crash, or a shutdown by another method.
10:49:45 [mysql] Press the Logs button to view error logs and check
10:49:45 [mysql] the Windows Event Viewer for more clues
10:49:45 [mysql] If you need more help, copy and post this
10:49:45 [mysql] entire log window on the forums

Thanks for the help.
3-4-SAD
 
Posts: 7
Joined: 30. July 2013 09:56
XAMPP Version: 5.5.19
Operating System: win 7

Re: Error: MySQL shutdown unexpectedly.

Postby Altrea » 05. August 2013 15:29

Okay, so we can say that the grayed out service icons (green tick / red cross) are no bug on your system. You didn't started the control panel with elevated administrator rights, but that is a requirement for all things doing with windows services.

Next thing we need is the contents of your mysql_error.log file.
And maybe you can check with help of the netstat tool in the control panel if some process is already using port 3306.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6697
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: Error: MySQL shutdown unexpectedly.

Postby hackattack142 » 05. August 2013 22:17

Hello,

In addition, you are running MySQL in standalone mode (not as a Service). Did you try my original suggestion to the person in the other post with this issue to try running MySQL as a Service (green check in the Service column of the Control Panel - requires running XAMPP Control Panel with Admin privileges)?
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
XAMPP Version: 5.6.3
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: Error: MySQL shutdown unexpectedly.

Postby 3-4-SAD » 06. August 2013 09:20

Altrea; I have started cpanel as admin so now I can click the check boxes

hackattack142; I have tried that but no luck :-(

Still can't start MySQL.
Here is the log: https://dl.dropboxusercontent.com/u/28273596/mysql_error.log
Netstat is showing that 3306 isn't occupied by any process

Thanks for the help guys...
3-4-SAD
 
Posts: 7
Joined: 30. July 2013 09:56
XAMPP Version: 5.5.19
Operating System: win 7

Re: Error: MySQL shutdown unexpectedly.

Postby Nobbie » 06. August 2013 12:04

I think you are struggling with this problem:

http://bugs.mysql.com/bug.php?id=67595
Nobbie
 
Posts: 6799
Joined: 09. March 2008 13:04

Re: Error: MySQL shutdown unexpectedly.

Postby 3-4-SAD » 07. August 2013 09:11

Nobbie, thanks a zillion.
That was it!

Who knew those files had to be deleted?!
I owe you a beer.
3-4-SAD
 
Posts: 7
Joined: 30. July 2013 09:56
XAMPP Version: 5.5.19
Operating System: win 7

Re: Error: MySQL shutdown unexpectedly.

Postby Nobbie » 07. August 2013 11:50

3-4-SAD wrote:I owe you a beer.


Lovely - where and when?
Nobbie
 
Posts: 6799
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: Frag and 43 guests