Error: MySQL shutdown unexpectedly

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

Error: MySQL shutdown unexpectedly

Postby marzia » 12. February 2021 07:55

Hello,
I am a beginner in using Wordpress on localhost. Please can you help me and please explain in an easy way (step by step) ;)
When I start the MySQL module in the Xampp control panel today (while it was perfectly working in the past 2 weeks) I get this error:

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

When pressing the Logs button I get following info:

2021-02-12 8:38:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-02-12 8:38:46 0 [Note] InnoDB: Uses event mutexes
2021-02-12 8:38:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-12 8:38:46 0 [Note] InnoDB: Number of pools: 1
2021-02-12 8:38:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-12 8:38:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-02-12 8:38:46 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-12 8:38:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-12 8:38:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-12 8:38:46 0 [Note] InnoDB: Setting file 'C:\Users\Marzia\Downloads\XAMPP-\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-12 8:38:46 0 [Note] InnoDB: File 'C:\Users\Marzia\Downloads\XAMPP-\mysql\data\ibtmp1' size is now 12 MB.
2021-02-12 8:38:46 0 [Note] InnoDB: Waiting for purge to start
2021-02-12 8:38:46 0 [Note] InnoDB: 10.4.17 started; log sequence number 45821107; transaction id 31685
2021-02-12 8:38:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\Users\Marzia \Downloads\XAMPP-\mysql\data\ib_buffer_pool
2021-02-12 8:38:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-12 8:38:46 0 [Note] Server socket created on IP: '::'.
marzia
 
Posts: 2
Joined: 12. February 2021 07:49
XAMPP version: v.3.2.4
Operating System: Windows

Error: MySQL shutdown unexpectedly + uninstall Xampp

Postby marzia » 12. February 2021 08:50

Hello,
I tried to fix the MySQL shutdown unexpectedly error with help of previous answers from the forum but I did not succeed.
I uninstalled Xampp and reinstalled it allowing the access to Windows Defender Firewall blocks on private and public networks. Now MySQL in Xampp is working again (!!) but I lost all my database and websites I have created on localhost!
How can I avoid to loose all my work next time when I have to uninstall/reinstall Xampp??
marzia
 
Posts: 2
Joined: 12. February 2021 07:49
XAMPP version: v.3.2.4
Operating System: Windows

Re: Error: MySQL shutdown unexpectedly

Postby Zeeshan15 » 13. February 2021 13:58

I have started facing a similar issue since yesterday. Previously, I had no such issue everything worked fine. Now, Im trying to find a fix to this issue.
Zeeshan15
 
Posts: 1
Joined: 13. February 2021 13:52
XAMPP version: 3.2.4
Operating System: Windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 76 guests