Error: MySQL shutdown unexpectedly.

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

Error: MySQL shutdown unexpectedly.

Postby stanleychan » 09. November 2023 00:04

Hello everyone, I would like to see whether I can get help on my issue because I cannot even finish my assignment and my final examination without having XAMPP running smoothly :cry:

Almost every time I start MySQL in the XAMPP control panel, it stops automatically with "Error: MySQL shutdown unexpectedly.". It still happens even after XAMPP reinstallation, opening the control panel as administrator, and using the data in backup folder.

Here is the log (but I cannot understand anything useful from that):
2023-11-08 14:53:02 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 7936
2023-11-08 14:53:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-08 14:53:02 0 [Note] InnoDB: Uses event mutexes
2023-11-08 14:53:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-08 14:53:02 0 [Note] InnoDB: Number of pools: 1
2023-11-08 14:53:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-08 14:53:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-08 14:53:02 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-08 14:53:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-08 14:53:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-08 14:53:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-08 14:53:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-08 14:53:02 0 [Note] InnoDB: Waiting for purge to start
2023-11-08 14:53:02 0 [Note] InnoDB: 10.4.28 started; log sequence number 4879054; transaction id 2399
2023-11-08 14:53:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-08 14:53:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-08 14:53:02 0 [Note] Server socket created on IP: '::'.


Meanwhile, I take a look at my window's Event Viewer and see the following error with MariaDB - not sure it is relevant or not.
Fatal error: Can't open and lock privilege tables: Incorrect file format 'global_priv'


I would be grateful if you could help me with this, thanks. :cry:
stanleychan
 
Posts: 1
Joined: 08. November 2023 23:55
XAMPP version: 8.2.4
Operating System: Windows 11

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 76 guests