MySQL is failing to startup

[jeffythedragonslayer]

Hi there, I recently installed XAMPP on Windows Server 2019, but today MySQL has started failing to startup. Here is what is printed in XAMPP's bottom text box:

Code: Select all

11:42:32 PM  [main]    Initializing Control Panel
11:42:32 PM  [main]    Windows Version:   64-bit
11:42:32 PM  [main]    XAMPP Version: 8.2.0
11:42:32 PM  [main]    Control Panel Version: 3.3.0  [ Compiled: Apr 6th 2021 ]
11:42:32 PM  [main]    Running with Administrator rights - good!
11:42:32 PM  [main]    XAMPP Installation Directory: "c:\xampp\"
11:42:32 PM  [main]    Checking for prerequisites
11:42:32 PM  [main]    All prerequisites found
11:42:32 PM  [main]    Initializing Modules
11:42:32 PM  [main]    Starting Check-Timer
11:42:32 PM  [main]    Control Panel Ready
11:42:36 PM  [mysql]    Attempting to start MySQL app...
11:42:37 PM  [mysql]    Status change detected: running
11:42:39 PM  [mysql]    Status change detected: stopped
11:42:39 PM  [mysql]    Error: MySQL shutdown unexpectedly.
11:42:39 PM  [mysql]    This may be due to a blocked port, missing dependencies,
11:42:39 PM  [mysql]    improper privileges, a crash, or a shutdown by another method.
11:42:39 PM  [mysql]    Press the Logs button to view error logs and check
11:42:39 PM  [mysql]    the Windows Event Viewer for more clues
11:42:39 PM  [mysql]    If you need more help, copy and post this
11:42:39 PM  [mysql]    entire log window on the forums

I have attached the mysql_error.log to a post over at the phpbb forums:

https://www.phpbb.com/community/viewtopic.php?p=15933941#p15933941

They directed me to ask here. Any help deciphering what went wrong would be greatly appreciated.

[jeffythedragonslayer]

I found a solution to this; will post maybe tomorrow.

[Altrea]

Hi,

your logs don't contain any helpful information about your issue.

Please try to start MariaDB as console application and tell us what log messages you get there:

• start the XAMPP shell by clicking the [Shell] button in your XAMPP control panel
• execute the following command
  

  Code: Select all

  mysqld --defaults-file=mysql\bin\my.ini --standalone --console

[jeffythedragonslayer]

This solution did the trick: https://stackoverflow.com/a/63663645

[Froosh]

I've heard of people having success with that approach, not sure if it is something I would do, or recommend doing, but glad it worked for you. What Altrea suggested would have likely started you down a path that has worked for me.

A possible suggestion would be if you are not running MySQL as a Windows Service, I would make sure you do so. I stopped having any MySQL database issues once I made that change. Before that, I was randomly having cases where MySQL would not start.