XAMPP v3.2.4 MySQL Shutdown Unexpectedly

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

XAMPP v3.2.4 MySQL Shutdown Unexpectedly

Postby AlexB345 » 08. September 2019 21:14

I have been trying to start MySQL on the XAMPP control panel but it keeps giving me the error log:

Code: Select all
12:58:21 PM  [mysql]    Status change detected: stopped
12:58:21 PM  [mysql]    Error: MySQL shutdown unexpectedly.
12:58:21 PM  [mysql]    This may be due to a blocked port, missing dependencies,
12:58:21 PM  [mysql]    improper privileges, a crash, or a shutdown by another method.
12:58:21 PM  [mysql]    Press the Logs button to view error logs and check
12:58:21 PM  [mysql]    the Windows Event Viewer for more clues
12:58:21 PM  [mysql]    If you need more help, copy and post this
12:58:21 PM  [mysql]    entire log window on the forums


Here is the Error Log file:
Code: Select all
2019-09-08 13:12:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-08 13:12:09 0 [Note] InnoDB: Uses event mutexes
2019-09-08 13:12:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-08 13:12:09 0 [Note] InnoDB: Number of pools: 1
2019-09-08 13:12:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-08 13:12:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-08 13:12:09 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-08 13:12:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
2019-09-08 13:12:10 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
2019-09-08 13:12:10 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
2019-09-08 13:12:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-08 13:12:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-08 13:12:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-08 13:12:11 0 [Note] InnoDB: Setting file 'C:\xampp3\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-08 13:12:11 0 [Note] InnoDB: File 'C:\xampp3\mysql\data\ibtmp1' size is now 12 MB.
2019-09-08 13:12:11 0 [Note] InnoDB: Waiting for purge to start
2019-09-08 13:12:11 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603975; transaction id 9
2019-09-08 13:12:11 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2019-09-08 13:12:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp3\mysql\data\ib_buffer_pool
2019-09-08 13:12:11 0 [Note] InnoDB: Cannot open 'C:\xampp3\mysql\data\ib_buffer_pool' for reading: No such file or directory
2019-09-08 13:12:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-08 13:12:11 0 [Note] Server socket created on IP: '::'.


I have been trying to use various solutions from other forums but I have no luck, not sure if it has to do with XAMPP and MariaDB not working together. If anyone has any solutions please feel free to respond, I need help.
AlexB345
 
Posts: 1
Joined: 08. September 2019 21:03
XAMPP version: 3.2.4
Operating System: Windows 10

Re: XAMPP v3.2.4 MySQL Shutdown Unexpectedly

Postby kenneth_peck » 11. September 2019 11:10

I had the same problem yesterday. Something is interfering with port 3306, which is the port MySQL uses.

Solution: Go to Task Manager and select the last tab, "Services". Scroll down to "MySQL80". Click on "Running" and select "Stop."
kenneth_peck
 
Posts: 1
Joined: 11. September 2019 10:55
XAMPP version: v3.2.4
Operating System: Windows 10 Pro


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 83 guests