Windows 10: Error: MySQL shutdown unexpectedly.

This may be due to a blocked port, missing dependencies, improper privileges, a crash, or a shutdown by another method.




here is the error log





InnoDB: using atomic writes.

2020-06-02 16:35:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-02 16:35:30 0 [Note] InnoDB: Uses event mutexes
2020-06-02 16:35:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-02 16:35:30 0 [Note] InnoDB: Number of pools: 1
2020-06-02 16:35:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-02 16:35:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-02 16:35:30 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-02 16:35:30 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2020-06-02 16:35:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-02 16:35:31 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-06-02 16:35:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-02 16:35:31 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-02 16:35:31 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-06-02 16:35:31 0 [Note] InnoDB: Waiting for purge to start
2020-06-02 16:35:31 0 [Note] InnoDB: 10.4.11 started; log sequence number 300297; transaction id 171
2020-06-02 16:35:31 0 [Note] InnoDB: Loading buffer pools from E:\xampp\mysql\data\ib_buffer_pool
2020-06-02 16:35:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-02 16:35:31 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-06-02 18:18:23 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-02 18:18:23 0 [Note] InnoDB: Uses event mutexes
2020-06-02 18:18:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-02 18:18:23 0 [Note] InnoDB: Number of pools: 1
2020-06-02 18:18:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-02 18:18:23 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-02 18:18:23 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-02 18:18:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=725816
2020-06-02 18:18:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-02 18:18:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-06-02 18:18:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-02 18:18:24 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-02 18:18:24 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-06-02 18:18:24 0 [Note] InnoDB: Waiting for purge to start
2020-06-02 18:18:24 0 [Note] InnoDB: 10.4.11 started; log sequence number 725825; transaction id 897
2020-06-02 18:18:24 0 [Note] InnoDB: Loading buffer pools from E:\xampp\mysql\data\ib_buffer_pool
2020-06-02 18:18:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-02 18:18:24 0 [Note] Server socket created on IP: '::'.
I

:)

 

How to completely uninstall MySQL?

Hi,

Thank you for writing to Microsoft Community Forums.

Which version of Windows is installed on your device?

Refer the article ‘Which Windows operating system am I running’
to provide the details.

I suggest you to follow the steps mentioned below to uninstall MySQL from the device.

Step 1

Uninstall MySQL from Control Panel. To do so,

Go to Control Panel >Programs and Features > Select
MySQL > Click on Uninstall.

After you have uninstalled MySQL through Add/Remove programs, you now need to remove the existing database information which includes your actual data. If you need any of that data, be sure to back it up. Next you can delete
the data directory.

Step 2

Run Command Prompt as Administrator and execute the following command to stop and remove MySQL service.

Net stop MySQL

Sc delete MySQL

Step 3

1. Click on Start, type in Show hidden files and folders.
   
2. Select the View tab and select
   Show hidden files and folders.
   
3. Now explore the following locations and delete following folders.
   
   C:\Program Files\MySQL
   
   C:\Program Files (x86)\MySQL
   
   C:\ProgramData\MySQL
   
   And if exists, delete the folder from the location.
   
   C:\Users\[User-Name]\AppData\Roaming\MySQL
   
4. Restart your device and check the status.
   

Get back to us for further assistance on this issue. We will be happy to help you.

Regards,

Muralidhar

Microsoft Community Moderator

 

Laptop shutdowns unexpectedly

Hello, i have the following issue, my laptop shutdowns unexpectedly and in the event viewer it showns that there was a cirtical error kernel power id 41 task category 63, i have no idea whats going on please help me, i
have windows 10.

 

Uninstall MySQL

Hi TayyabDitta,

I'm an Independent Advisor and consumer of Microsoft products just like you. Let me help you with your concern.

You have to uninstall all the programs in the list with MySQL on their name.

After uninstalling all MySQL related programs, please follow the below link to fully uninstall or remove remaining files/directories safely:

https://answers.microsoft.com/en-us/windows/for...