I am running 10.4.11 MariaDB
Recently, My XAMPP controller failed to start MySQL (MariaDB). I got the following error:
Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies,
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums
I checked the MySQL log file, no error was recorded. I changed the port configuration to 3307, process still failed. I started the MySQL demon in command line in verbose mode to check for errors, no errors show up (no process created either despite getting a message saying it did!). I opened the Windows Event Viewer and saw, among other things, the following error message from MySQL:
Failed to initialize multi master structures
Here’s what I did that fixed the problem:
- rename folder xampp/mysql/data to something else, like data-org
- create a new folder name data
- copy over all the table folders from data-org to data
- copy over my.ini and ibdata1. My.ini contains configuration information and ibdata1 contains the table definition.
- start MySQL
No data was lost. I did not need to reinstall XAMPP. All is well!