my sql conection

[BetoNN]

I installed Xamp and started working on a website on my computer (windows 10). It worked perfectly, until all of a sudden the database stopped connecting. I have a great job done and I can't miss it.

Log:
022-08-28 14:27:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-28 14:27:57 0 [Note] InnoDB: Uses event mutexes
2022-08-28 14:27:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-28 14:27:57 0 [Note] InnoDB: Number of pools: 1
2022-08-28 14:27:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-28 14:27:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-28 14:27:57 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-28 14:27:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-28 14:27:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-28 14:27:58 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-28 14:27:58 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-28 14:27:58 0 [Note] InnoDB: Waiting for purge to start
2022-08-28 14:27:58 0 [Note] InnoDB: 10.4.24 started; log sequence number 68067245; transaction id 30899
2022-08-28 14:27:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-28 14:27:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-28 14:27:58 0 [Note] Server socket created on IP: '::'.
2022-08-28 14:28:14 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-28 14:28:14 0 [Note] InnoDB: Uses event mutexes
2022-08-28 14:28:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-28 14:28:14 0 [Note] InnoDB: Number of pools: 1
2022-08-28 14:28:14 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-28 14:28:14 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-28 14:28:14 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-28 14:28:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-28 14:28:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-28 14:28:15 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-28 14:28:15 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-28 14:28:15 0 [Note] InnoDB: Waiting for purge to start
2022-08-28 14:28:15 0 [Note] InnoDB: 10.4.24 started; log sequence number 68067254; transaction id 30899
2022-08-28 14:28:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-28 14:28:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-28 14:28:15 0 [Note] Server socket created on IP: '::'.

Thanks for any help!

BetoNN

[BetoNN]

08:42:26 [Apache] Status change detected: running
08:42:31 [mysql] Attempting to start MySQL app...
08:42:31 [mysql] Status change detected: running
08:42:34 [mysql] Status change detected: stopped
08:42:34 [mysql] Error: MySQL shutdown unexpectedly.
08:42:34 [mysql] This may be due to a blocked port, missing dependencies,
08:42:34 [mysql] improper privileges, a crash, or a shutdown by another method.
08:42:34 [mysql] Press the Logs button to view error logs and check
08:42:34 [mysql] the Windows Event Viewer for more clues
08:42:34 [mysql] If you need more help, copy and post this
08:42:34 [mysql] entire log window on the forums

[Froosh]

More information is often needed to suggest solutions. I suggest you search this forum, and you should find possible solutions to the issue. For instance, in this post viewtopic.php?f=16&t=82204&p=277080&hilit=mysql+blocked+port+missing+dependencies#p277080 a suggestion is made to execute a command and post the result to further assist with the diagnosis.

Depending on what is determined, from that, there may be further solutions, for example, you could review this post to see if the solution matches your situation viewtopic.php?f=16&t=81986&p=276402&hilit=mysql+blocked+port+missing+dependencies#p276402

I also suggest that once you fix the unexpected database issue, that you configure XAMPP to at least start MySQL as a Windows Service. The current release appears unreliable when MySQL is started as a regular application from the XAMPP Control Panel.

[mr.blade39]

XAMPP APP
22:40:04 [mysql] Attempting to start MySQL service...
22:40:09 [mysql] Status change detected: running
22:40:14 [mysql] Status change detected: stopped
22:40:14 [mysql] Error: MySQL shutdown unexpectedly.
22:40:14 [mysql] This may be due to a blocked port, missing dependencies,
22:40:14 [mysql] improper privileges, a crash, or a shutdown by another method.
22:40:14 [mysql] Press the Logs button to view error logs and check
22:40:14 [mysql] the Windows Event Viewer for more clues
22:40:14 [mysql] If you need more help, copy and post this
22:40:14 [mysql] entire log window on the forums


LOGS MySQL
2022-08-30 22:38:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-30 22:38:48 0 [Note] InnoDB: Uses event mutexes
2022-08-30 22:38:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-30 22:38:48 0 [Note] InnoDB: Number of pools: 1
2022-08-30 22:38:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-30 22:38:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-30 22:38:48 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-30 22:38:48 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 7974831 between the checkpoint 7974831 and the end 7974400.
2022-08-30 22:38:48 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-08-30 22:38:48 0 [Note] InnoDB: Starting shutdown...
2022-08-30 22:38:48 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-08-30 22:38:48 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-08-30 22:38:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-30 22:38:48 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-08-30 22:38:48 0 [ERROR] Aborting