MySQL Stops after starting it. XAmpp 7.4.7

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

Re: MySQL Stops after starting it. XAmpp 7.4.7

Postby MRevolver » 16. January 2022 19:39

Here is the solution I found and worked for me

https://itectec.com/database/thesql-error-mysql-shutdown-unexpectedly/

1.- Rename the folder mysql/data to mysql/data_old (you can use any name)
2.- Create a new folder mysql/data
3.- Copy the content that resides in mysql/backup to the new mysql/data folder
4.- Copy all your database folders that are in mysql/data_old to mysql/data
5.- Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
6.- Start MySQL from XAMPP control panel
MRevolver
 
Posts: 1
Joined: 16. January 2022 19:37
XAMPP version: 3.2.4
Operating System: Windows 10

Re: MySQL Stops after starting it. XAmpp 7.4.7

Postby khiemnm » 08. March 2022 18:21

Hi all,
I got the same issue. I did remove mysql/data/mysql folder. And copy mysql folder from backup folder to data folder.
Then It works like a champ.
khiemnm
 
Posts: 1
Joined: 08. March 2022 18:19
XAMPP version: v3.3.0
Operating System: Window

Re: MySQL Stops after starting it. XAmpp 7.4.7

Postby Novaxampp » 10. April 2022 16:35

This was happening with xampp version 8.0.12
I found the solution on StackOverflow in this post: https://stackoverflow.com/questions/62797324/unable-to-start-mysql-via-xampp-mysql-db-crashed

I made a video of the steps below which you can watch at: https://www.screencast.com/t/aNaXzyDsOlz

The text instructions are:

Find and open the 'my.ini' file with Notepad. (Mine is at c:\xampp\mysql\bin\my.ini ) NOT the one in the "data" folder.

Insert 'skip-grant-tables' in the 'my.ini' file on a new line following the label '[mysqld]' and save. You will remove this after the problem is fixed.

Now mySQL you can start XAMPP from the control panel.

Start phpMyAdmin from your browser and select the table 'db' from the database 'mysql' (Select 'mysql' from left panel then check 'db' in right hand panel).

Beneath from the 'With selected' dropdown, run 'analyze' (it should say that it is corrupted). Then select again and run 'repair table'.

Find the 'my.ini' file again and open with Notepad.

Remove 'skip-grant-tables' in the 'my.ini' file and save.

Problem should be fixed and you should be able to start XAMPP normally which will start MySQL normally.
Novaxampp
 
Posts: 1
Joined: 10. April 2022 16:02
XAMPP version: 8.0.12
Operating System: Windows 11 Pro 21H2

Re: MySQL Stops after starting it. XAmpp 7.4.7

Postby timwakeling » 28. April 2023 14:04

You are a genius! These steps solved my problem too. Thank you!

Tim
timwakeling
 
Posts: 1
Joined: 28. April 2023 14:03
XAMPP version: 8.2.0
Operating System: Windows 11

Re: MySQL Stops after starting it. XAmpp 7.4.7

Postby ipvye » 26. December 2023 01:39

Eradan's solution worked out for me too. Thank you.
ipvye
 
Posts: 1
Joined: 26. December 2023 01:35
XAMPP version: 8
Operating System: Cross Platform

Previous

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 44 guests