XAMPP: MySQL Crashes on startup

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

XAMPP: MySQL Crashes on startup

Postby topograph » 03. May 2017 08:53

Hi!
I have a problem: When i start mysql it immediatly crashed with this message:
09:52:47 [mysql] Error: MySQL shutdown unexpectedly.
09:52:47 [mysql] This may be due to a blocked port, missing dependencies,
09:52:47 [mysql] improper privileges, a crash, or a shutdown by another method.
09:52:47 [mysql] Press the Logs button to view error logs and check
09:52:47 [mysql] the Windows Event Viewer for more clues
09:52:47 [mysql] If you need more help, copy and post this
09:52:47 [mysql] entire log window on the forums

What i have tried so far:
  • Fresh installation of XAMPP
  • Checked if port is blocked by another application -> its free
  • Checked if skype or similar is installed -> its not
  • tried MAMP instead of XAMPP -> Same problem.

What could be the problem? I dont understand the log :(
topograph
 
Posts: 2
Joined: 03. May 2017 08:45
XAMPP version: 3.2.2
Operating System: Windows 10 Pro

Re: XAMPP: MySQL Crashes on startup

Postby topograph » 03. May 2017 12:42

Solved it:
add this line to config file (my.ini in programData...)

innodb_flush_method=normal


from this answer helped me: http://stackoverflow.com/a/22469514

its apparently linked to this bug: https://bugs.mysql.com/bug.php?id=28913
topograph
 
Posts: 2
Joined: 03. May 2017 08:45
XAMPP version: 3.2.2
Operating System: Windows 10 Pro


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 117 guests