Error: MySQL shutdown unexpectedly.

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

Error: MySQL shutdown unexpectedly.

Postby killer_x10 » 05. September 2015 10:03

Code: Select all
10.53.21  [mysql]    Error: MySQL shutdown unexpectedly.
10.53.21  [mysql]    This may be due to a blocked port, missing dependencies,
10.53.21  [mysql]    improper privileges, a crash, or a shutdown by another method.
10.53.21  [mysql]    Press the Logs button to view error logs and check
10.53.21  [mysql]    the Windows Event Viewer for more clues
10.53.21  [mysql]    If you need more help, copy and post this
10.53.21  [mysql]    entire log window on the forums


This is what I get every time I start MySQL, I have searched many Forums and Answers (in Stackoverflow, etc.) and found that I have to stop XAMPP, delete "ibdata1" File and then restart it (and this FIX worked for all of the People there except for me), didn't work.. I tried numerous time the same thing. Then tried another thing, where I had to add a Code to the my.ini File, which I did and it didn't work either. Here's my Error Log: http://pastebin.com/hHCU6ngy
killer_x10
 
Posts: 6
Joined: 05. September 2015 09:56
Operating System: Windows

Re: Error: MySQL shutdown unexpectedly.

Postby Altrea » 05. September 2015 10:51

That is not your error log, that is your my.ini config file.
Without knowing the mysql_error.log contents nobody can analyze your problem except you
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: 8299
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Error: MySQL shutdown unexpectedly.

Postby killer_x10 » 05. September 2015 11:37

Altrea wrote:That is not your error log, that is your my.ini config file.
Without knowing the mysql_error.log contents nobody can analyze your problem except you


Hi, I am extremely sorry, it was a mistake. This is the Error Log: http://pastebin.com/Wp1zHbA7
killer_x10
 
Posts: 6
Joined: 05. September 2015 09:56
Operating System: Windows

Re: Error: MySQL shutdown unexpectedly.

Postby Nobbie » 05. September 2015 12:25

This the main error (first happened see timestamp):

c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
2015-09-05 00:19:27 15004 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.


Someone/something/somewhat has destroyed your installation, there is missing a table "plugin" in your mysql database (mysql database is the core database for MySQL). Try to run mysql_upgrade as suggested. Anyway, this looks very strange, i cannot tell you, what has happened to your PC.
Nobbie
 
Posts: 8780
Joined: 09. March 2008 13:04

Re: Error: MySQL shutdown unexpectedly.

Postby killer_x10 » 05. September 2015 19:11

Nobbie wrote:This the main error (first happened see timestamp):

c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
2015-09-05 00:19:27 15004 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.


Someone/something/somewhat has destroyed your installation, there is missing a table "plugin" in your mysql database (mysql database is the core database for MySQL). Try to run mysql_upgrade as suggested. Anyway, this looks very strange, i cannot tell you, what has happened to your PC.


I'm kinda new to Xampp and all of these.. so I kinda don't know what to do now
killer_x10
 
Posts: 6
Joined: 05. September 2015 09:56
Operating System: Windows

Re: Error: MySQL shutdown unexpectedly.

Postby Altrea » 05. September 2015 19:43

You had to find a file named mysql_upgrade and execute it.

Alternatively you can uninstall and reinstall XAMPP entirely which should work in all cases
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: 8299
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Error: MySQL shutdown unexpectedly.

Postby killer_x10 » 05. September 2015 20:22

Altrea wrote:You had to find a file named mysql_upgrade and execute it.

Alternatively you can uninstall and reinstall XAMPP entirely which should work in all cases


I have executed the file but still doesn't work, I'm just gonna go for the reinstallation method now, even though I am going to loose my Databases
killer_x10
 
Posts: 6
Joined: 05. September 2015 09:56
Operating System: Windows

Re: Error: MySQL shutdown unexpectedly.

Postby killer_x10 » 05. September 2015 21:49

Hi, I have reinstalled it and it seems that MySQL is working again but Apache won't:

Code: Select all
22.47.30  [Apache]    Status change detected: stopped
22.47.30  [Apache]    Error: Apache shutdown unexpectedly.
22.47.30  [Apache]    This may be due to a blocked port, missing dependencies,
22.47.30  [Apache]    improper privileges, a crash, or a shutdown by another method.
22.47.30  [Apache]    Press the Logs button to view error logs and check
22.47.30  [Apache]    the Windows Event Viewer for more clues
22.47.30  [Apache]    If you need more help, copy and post this
22.47.30  [Apache]    entire log window on the forums


Error Log:
Code: Select all
[Sat Sep 05 22:44:35.798358 2015] [ssl:warn] [pid 48744:tid 568] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Sep 05 22:44:36.198250 2015] [ssl:warn] [pid 48744:tid 568] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Sep 05 22:44:36.770008 2015] [mpm_winnt:notice] [pid 48744:tid 568] AH00455: Apache/2.4.16 (Win32) OpenSSL/1.0.1p PHP/5.6.12 configured -- resuming normal operations
[Sat Sep 05 22:44:36.770008 2015] [mpm_winnt:notice] [pid 48744:tid 568] AH00456: Apache Lounge VC11 Server built: Jul 12 2015 10:56:48
[Sat Sep 05 22:44:36.770008 2015] [core:notice] [pid 48744:tid 568] AH00094: Command line: 'C:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache'
[Sat Sep 05 22:44:36.770008 2015] [mpm_winnt:notice] [pid 48744:tid 568] AH00418: Parent: Created child process 48460
[Sat Sep 05 22:44:37.469290 2015] [ssl:warn] [pid 48460:tid 568] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Sep 05 22:44:37.723514 2015] [ssl:warn] [pid 48460:tid 568] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Sep 05 22:44:37.786019 2015] [mpm_winnt:notice] [pid 48460:tid 568] AH00354: Child: Starting 150 worker threads.
killer_x10
 
Posts: 6
Joined: 05. September 2015 09:56
Operating System: Windows

Re: Error: MySQL shutdown unexpectedly.

Postby killer_x10 » 06. September 2015 10:04

I fixed the Apache error, found out that Apache was actually already running in the Background
killer_x10
 
Posts: 6
Joined: 05. September 2015 09:56
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 32 guests