Error: MySQL shutdown unexpectedly.

[stp1963]

Habe gerade erst neu installiert und die db's vom Dump wiederhergestellt. Port ist frei, denn mit mysql skip-grant-tables, mysql -> mysql service restart ist die Welt wieder in Ordnung. XAMPP läuft direkt auf C: auf OS Name Microsoft Windows 11 Pro Version 10.0.22631 Build 22631 seit Jahren benutze ich es Fehlerfrei. Auf meinen anderen Maschinen Win 10 hatte ich bisher keine Probleme.

2:19:55 PM [mysql] Status change detected: stopped
2:19:55 PM [mysql] Error: MySQL shutdown unexpectedly.
2:19:55 PM [mysql] This may be due to a blocked port, missing dependencies,
2:19:55 PM [mysql] improper privileges, a crash, or a shutdown by another method.
2:19:55 PM [mysql] Press the Logs button to view error logs and check
2:19:55 PM [mysql] the Windows Event Viewer for more clues
2:19:55 PM [mysql] If you need more help, copy and post this
2:19:55 PM [mysql] entire log window on the forums
2:21:35 PM [mysql] Status change detected: running
2:21:44 PM [main] Executing "c:\xampp\"

mysql_error:

2024-04-19 14:08:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-19 14:08:29 0 [Note] InnoDB: Buffer pool(s) load completed at 240419 14:08:29
2024-04-19 14:08:29 0 [Note] Server socket created on IP: '::'.
2024-04-19 14:10:37 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 25348
2024-04-19 14:10:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-19 14:10:37 0 [Note] InnoDB: Uses event mutexes
2024-04-19 14:10:37 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-19 14:10:37 0 [Note] InnoDB: Number of pools: 1
2024-04-19 14:10:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-19 14:10:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-19 14:10:37 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-19 14:10:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-19 14:10:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-19 14:10:38 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-19 14:10:38 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-19 14:10:38 0 [Note] InnoDB: Waiting for purge to start
2024-04-19 14:10:38 0 [Note] InnoDB: 10.4.32 started; log sequence number 2975578; transaction id 4849
2024-04-19 14:10:38 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-19 14:10:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-19 14:10:38 0 [Note] InnoDB: Buffer pool(s) load completed at 240419 14:10:38
2024-04-19 14:10:38 0 [Note] Server socket created on IP: '::'.
2024-04-19 14:11:53 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 24868
2024-04-19 14:11:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-19 14:11:53 0 [Note] InnoDB: Uses event mutexes
2024-04-19 14:11:53 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-19 14:11:53 0 [Note] InnoDB: Number of pools: 1
2024-04-19 14:11:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-19 14:11:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-19 14:11:53 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-19 14:11:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-19 14:11:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-19 14:11:53 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-19 14:11:53 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-19 14:11:53 0 [Note] InnoDB: Waiting for purge to start
2024-04-19 14:11:53 0 [Note] InnoDB: 10.4.32 started; log sequence number 2975587; transaction id 4849
2024-04-19 14:11:53 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-19 14:11:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-19 14:11:53 0 [Note] InnoDB: Buffer pool(s) load completed at 240419 14:11:53
2024-04-19 14:11:53 0 [Note] Server socket created on IP: '::'.
2024-04-19 14:12:18 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 19684
2024-04-19 14:12:18 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-19 14:12:18 0 [Note] InnoDB: Uses event mutexes
2024-04-19 14:12:18 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-19 14:12:18 0 [Note] InnoDB: Number of pools: 1
2024-04-19 14:12:18 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-19 14:12:18 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-19 14:12:18 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-19 14:12:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-19 14:12:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-19 14:12:18 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-19 14:12:18 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-19 14:12:18 0 [Note] InnoDB: Waiting for purge to start
2024-04-19 14:12:18 0 [Note] InnoDB: 10.4.32 started; log sequence number 2975596; transaction id 4849
2024-04-19 14:12:18 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-19 14:12:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-19 14:12:18 0 [Note] Server socket created on IP: '::'.
2024-04-19 14:12:18 0 [Note] InnoDB: Buffer pool(s) load completed at 240419 14:12:18
2024-04-19 14:12:29 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 5140
2024-04-19 14:12:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-19 14:12:29 0 [Note] InnoDB: Uses event mutexes
2024-04-19 14:12:29 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-19 14:12:29 0 [Note] InnoDB: Number of pools: 1
2024-04-19 14:12:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-19 14:12:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-19 14:12:29 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-19 14:12:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-19 14:12:29 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-19 14:12:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-19 14:12:29 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-19 14:12:29 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-19 14:12:29 0 [Note] InnoDB: Waiting for purge to start
2024-04-19 14:12:29 0 [Note] InnoDB: 10.4.32 started; log sequence number 2975596; transaction id 4849
2024-04-19 14:12:29 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-19 14:12:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-19 14:12:29 0 [Note] Server socket created on IP: '::'.
2024-04-19 14:13:38 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 9284
2024-04-19 14:13:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-19 14:13:38 0 [Note] InnoDB: Uses event mutexes
2024-04-19 14:13:38 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-19 14:13:38 0 [Note] InnoDB: Number of pools: 1
2024-04-19 14:13:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-19 14:13:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-19 14:13:38 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-19 14:13:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-19 14:13:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-19 14:13:39 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-19 14:13:39 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-19 14:13:39 0 [Note] InnoDB: Waiting for purge to start
2024-04-19 14:13:39 0 [Note] InnoDB: 10.4.32 started; log sequence number 2975605; transaction id 4849
2024-04-19 14:13:39 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-19 14:13:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-19 14:13:39 0 [Note] Server socket created on IP: '::'.
2024-04-19 14:13:39 0 [Note] InnoDB: Buffer pool(s) load completed at 240419 14:13:39
2024-04-19 14:17:02 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 22928
2024-04-19 14:17:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-19 14:17:02 0 [Note] InnoDB: Uses event mutexes
2024-04-19 14:17:02 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-19 14:17:02 0 [Note] InnoDB: Number of pools: 1
2024-04-19 14:17:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-19 14:17:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-19 14:17:02 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-19 14:17:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-19 14:17:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-19 14:17:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-19 14:17:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-19 14:17:02 0 [Note] InnoDB: Waiting for purge to start
2024-04-19 14:17:02 0 [Note] InnoDB: 10.4.32 started; log sequence number 2975614; transaction id 4849
2024-04-19 14:17:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-19 14:17:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-19 14:17:02 0 [Note] InnoDB: Buffer pool(s) load completed at 240419 14:17:02
2024-04-19 14:17:02 0 [Note] Server socket created on IP: '::'.
2024-04-19 14:17:19 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 14744
2024-04-19 14:17:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-19 14:17:19 0 [Note] InnoDB: Uses event mutexes
2024-04-19 14:17:19 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-19 14:17:19 0 [Note] InnoDB: Number of pools: 1
2024-04-19 14:17:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-19 14:17:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-19 14:17:19 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-19 14:17:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-19 14:17:19 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-19 14:17:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-19 14:17:19 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-19 14:17:19 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-19 14:17:19 0 [Note] InnoDB: Waiting for purge to start
2024-04-19 14:17:19 0 [Note] InnoDB: 10.4.32 started; log sequence number 2975614; transaction id 4849
2024-04-19 14:17:19 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-19 14:17:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-19 14:17:19 0 [Note] Server socket created on IP: '::'.
2024-04-19 14:17:19 0 [Note] InnoDB: Buffer pool(s) load completed at 240419 14:17:19
2024-04-19 14:17:19 0 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'proxies_priv'
2024-04-19 14:17:19 0 [ERROR] Aborting

[dburucu]

Habe das Problem seit längerem (min. 5 Monate). Manchmal werden die mysql-Datenbank-Benutzer und andere Daten zerstört. Muss oft die Datenbank neu installieren bzw. den Backup-Ordner in data-Ordner kopieren und alle Datenbanken neu importieren. Eine Lösung wäre super.