Apache Friends Support Forum

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

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

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

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 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

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

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

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.


I fixed the Apache error, found out that Apache was actually already running in the Background