hello,
I have installed xampp, I start the apache and it works, then I click on mysql , its stops and give me error.
the error message is below, it was working yesterday perfect, I don't change anything, I don't know what happen. If anyone can help me with it, it would be great. Thanks in advance.
error:
[code]10:02:27 AM [main] Initializing Control Panel
10:02:27 AM [main] Windows Version: Home 64-bit
10:02:27 AM [main] XAMPP Version: 7.4.16
10:02:27 AM [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
10:02:27 AM [main] Running with Administrator rights - good!
10:02:27 AM [main] XAMPP Installation Directory: "c:\xampp\"
10:02:27 AM [main] Checking for prerequisites
10:02:27 AM [main] All prerequisites found
10:02:27 AM [main] Initializing Modules
10:02:27 AM [main] Starting Check-Timer
10:02:27 AM [main] Control Panel Ready
10:02:29 AM [Apache] Attempting to start Apache app...
10:02:29 AM [Apache] Status change detected: running
10:02:32 AM [mysql] Attempting to start MySQL app...
10:02:32 AM [mysql] Status change detected: running
10:02:34 AM [mysql] Status change detected: stopped
10:02:34 AM [mysql] Error: MySQL shutdown unexpectedly.
10:02:34 AM [mysql] This may be due to a blocked port, missing dependencies,
10:02:34 AM [mysql] improper privileges, a crash, or a shutdown by another method.
10:02:34 AM [mysql] Press the Logs button to view error logs and check
10:02:34 AM [mysql] the Windows Event Viewer for more clues
10:02:34 AM [mysql] If you need more help, copy and post this
10:02:34 AM [mysql] entire log window on the forums
[/code]
and this is the log file:
[code]InnoDB: using atomic writes.
2021-04-23 14:49:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-04-23 14:49:47 0 [Note] InnoDB: Uses event mutexes
2021-04-23 14:49:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-04-23 14:49:47 0 [Note] InnoDB: Number of pools: 1
2021-04-23 14:49:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-04-23 14:49:47 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-04-23 14:49:47 0 [Note] InnoDB: Completed initialization of buffer pool
2021-04-23 14:49:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2021-04-23 14:49:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-04-23 14:49:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-04-23 14:49:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-23 14:49:47 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-04-23 14:49:47 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-04-23 14:49:47 0 [Note] InnoDB: Waiting for purge to start
2021-04-23 14:49:48 0 [Note] InnoDB: 10.4.18 started; log sequence number 300297; transaction id 170
2021-04-23 14:49:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-04-23 14:49:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-04-23 14:49:48 0 [Note] InnoDB: Buffer pool(s) load completed at 210423 14:49:48
2021-04-23 14:49:48 0 [Note] Server socket created on IP: '::'.
2021-04-23 18:03:51 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 100% (0.0 seconds); tables to flush: 1 0
(0.0 seconds);
2021-04-23 18:03:51 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2021-04-23 18:03:51 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-04-23 18:03:51 0 [Note] InnoDB: Uses event mutexes
2021-04-23 18:03:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-04-23 18:03:51 0 [Note] InnoDB: Number of pools: 1
2021-04-23 18:03:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-04-23 18:03:51 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-04-23 18:03:51 0 [Note] InnoDB: Completed initialization of buffer pool
2021-04-23 18:03:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=301618
2021-04-23 18:03:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-04-23 18:03:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-04-23 18:03:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-23 18:03:51 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-04-23 18:03:51 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-04-23 18:03:51 0 [Note] InnoDB: Waiting for purge to start
2021-04-23 18:03:52 0 [Note] InnoDB: 10.4.18 started; log sequence number 301627; transaction id 199
2021-04-23 18:03:52 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-04-23 18:03:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-04-23 18:03:52 0 [Note] InnoDB: Buffer pool(s) load completed at 210423 18:03:52
2021-04-23 18:03:52 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-04-24 0:05:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-04-24 0:05:37 0 [Note] InnoDB: Uses event mutexes
2021-04-24 0:05:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-04-24 0:05:37 0 [Note] InnoDB: Number of pools: 1
2021-04-24 0:05:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-04-24 0:05:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-04-24 0:05:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-04-24 0:05:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=301636
2021-04-24 0:05:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-04-24 0:05:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-04-24 0:05:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-24 0:05:37 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[/code]