Error: MySQL shutdown unexpectedly

Here is the screenshot of my XAMPP Control panel:



Here is my Error Log :

```
2019-11-27 7:54:14 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-27 7:54:14 0 [Note] InnoDB: Uses event mutexes
2019-11-27 7:54:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-27 7:54:14 0 [Note] InnoDB: Number of pools: 1
2019-11-27 7:54:14 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-27 7:54:14 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-27 7:54:14 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-27 7:54:14 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1791378
2019-11-27 7:54:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-27 7:54:14 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-27 7:54:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-27 7:54:14 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-27 7:54:14 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-27 7:54:14 0 [Note] InnoDB: Waiting for purge to start
2019-11-27 7:54:15 0 [Note] InnoDB: 10.3.16 started; log sequence number 1791387; transaction id 163
2019-11-27 7:54:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-27 7:54:15 0 [Note] InnoDB: Buffer pool(s) load completed at 191127 7:54:15
2019-11-27 7:54:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-27 7:54:15 0 [Note] Server socket created on IP: '::'.
2019-11-28 5:07:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-28 5:07:13 0 [Note] InnoDB: Uses event mutexes
2019-11-28 5:07:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-28 5:07:13 0 [Note] InnoDB: Number of pools: 1
2019-11-28 5:07:13 0 [Note] InnoDB: Using SSE2 crc32 instr

I came across similar problem and tried this Stack Overflow answer by Fabrizio Valencia. It worked.

Stop there! Please do not delete anything! First try to do what I did.

OK, none of the listed answers here solved my problem, even, some of
the answers were making me lost all my db data. So I did exactly what
the error message in XAMPP message panel told me to do. So I did this:

• Rename the folder mysql/data to mysql/data_old (you can use any name)

• Create a new folder mysql/data

• Copy the content that resides in mysql/backup to the new mysql/data folder

• Copy all your database folders that are in mysql/data_old to mysql/data

• Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder

• Start MySQL from XAMPP control panel

And, voilà. No databases lost, no ports changed, no run as
administrator, no force recovery, no kill mysqld process, no restoring
from previous versions, no more errors.

StackExchange Database Administrators Q#256758, answer score: 14