MySQL shutdown unexpectedly.

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

MySQL shutdown unexpectedly.

Postby sanchi » 14. January 2020 11:10

Error: MySQL shutdown unexpectedly.
3.30.42 PM [mysql] This may be due to a blocked port, missing dependencies,
3.30.42 PM [mysql] improper privileges, a crash, or a shutdown by another method.
3.30.42 PM [mysql] Press the Logs button to view error logs and check
3.30.42 PM [mysql] the Windows Event Viewer for more clues
3.30.42 PM [mysql] If you need more help, copy and post this
3.30.42 PM [mysql] entire log window on the forums
sanchi
 
Posts: 1
Joined: 14. January 2020 11:06
XAMPP version: 3.2.2
Operating System: windows10

Re: MySQL shutdown unexpectedly.

Postby manuj » 17. January 2020 20:55

I m facing the same issue since 14.1.2020. Tried changing the access port but no use. Even watched tons of youtube videos still and followed their steps still no use. pls help me resolve this

01:11:20 [mysql] Error: MySQL shutdown unexpectedly.
01:11:20 [mysql] This may be due to a blocked port, missing dependencies,
01:11:20 [mysql] improper privileges, a crash, or a shutdown by another method.
01:11:20 [mysql] Press the Logs button to view error logs and check
01:11:20 [mysql] the Windows Event Viewer for more clues
01:11:20 [mysql] If you need more help, copy and post this
01:11:20 [mysql] entire log window on the forums
manuj
 
Posts: 1
Joined: 17. January 2020 20:49
XAMPP version: 3.2.4
Operating System: windows 10 os

Re: MySQL shutdown unexpectedly.

Postby il_dottore » 19. January 2020 11:34

Same for me. This is my log file

InnoDB: using atomic writes.
2020-01-19 11:33:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-01-19 11:33:04 0 [Note] InnoDB: Uses event mutexes
2020-01-19 11:33:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-01-19 11:33:04 0 [Note] InnoDB: Number of pools: 1
2020-01-19 11:33:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-01-19 11:33:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-01-19 11:33:04 0 [Note] InnoDB: Completed initialization of buffer pool
2020-01-19 11:33:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-01-19 11:33:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-01-19 11:33:04 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-01-19 11:33:04 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-01-19 11:33:04 0 [Note] InnoDB: Waiting for purge to start
2020-01-19 11:33:04 0 [Note] InnoDB: 10.4.6 started; log sequence number 114142; transaction id 9
2020-01-19 11:33:04 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-01-19 11:33:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-01-19 11:33:04 0 [Note] InnoDB: Buffer pool(s) load completed at 200119 11:33:04
2020-01-19 11:33:04 0 [Note] Server socket created on IP: '::'.
il_dottore
 
Posts: 10
Joined: 09. October 2019 18:13
XAMPP version: 7.3.12
Operating System: Windows 10 64 bit

Re: MySQL shutdown unexpectedly.

Postby il_dottore » 19. January 2020 12:09

For now I solved the problem reinstalling Xampp. I had a DB back up and reimport it.
For now it works again
il_dottore
 
Posts: 10
Joined: 09. October 2019 18:13
XAMPP version: 7.3.12
Operating System: Windows 10 64 bit

Re: MySQL shutdown unexpectedly.

Postby il_dottore » 23. January 2020 19:22

Nothing to do. Now i tried again to start mysql but have the same problem
il_dottore
 
Posts: 10
Joined: 09. October 2019 18:13
XAMPP version: 7.3.12
Operating System: Windows 10 64 bit


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 151 guests