Page 1 of 1

XAMPP: MySQL Crashes on startup

PostPosted: 03. May 2017 08:53
by topograph
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 :(

Re: XAMPP: MySQL Crashes on startup

PostPosted: 03. May 2017 12:42
by topograph
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