How to solve "Error: MySQL shutdown unexpectedly"?

Question

When I open XAMPP and click start MySQL button and it gives me an error. I had started it just before, but now it isn't working.

12:19:12 PM [mysql] Attempting to start MySQL app...
12:19:12 PM [mysql] Status change detected: running
12:19:13 PM [mysql] Status change detected: stopped
12:19:13 PM [mysql] Error: MySQL shutdown unexpectedly.
12:19:13 PM [mysql] This may be due to a blocked port, missing dependencies,
12:19:13 PM [mysql] improper privileges, a crash, or a shutdown by another method
12:19:13 PM [mysql] Press the Logs button to view error logs and check
12:19:13 PM [mysql] the Windows Event Viewer for more clues
12:19:13 PM [mysql] If you need more help, copy and post this
12:19:13 PM [mysql] entire log window on the forums

Here is the contents of the error log:

2013-08-02 12:19:12 4536 [Note] Plugin 'FEDERATED' is disabled.
2013-08-02 12:19:12 f64 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2013-08-02 12:19:12 4536 [Note] InnoDB: The InnoDB memory heap is disabled
2013-08-02 12:19:12 4536 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-08-02 12:19:12 4536 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-08-02 12:19:12 4536 [Note] InnoDB: Not using CPU crc32 instructions
2013-08-02 12:19:12 4536 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-08-02 12:19:12 4536 [Note] InnoDB: Completed initialization of buffer pool
2013-08-02 12:19:12 4536 [Note] InnoDB: Highest supported file format is Barracuda.
2013-08-02 12:19:12 4536 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1616798 in the ib_logfiles!
2013-08-02 12:19:12 4536 [Note] InnoDB: Database was not shutdown normally!
2013-08-02 12:19:12 4536 [Note] InnoDB: Starting crash recovery.
2013-08-02 12:19:12 4536 [Note] InnoDB: Reading tablespace information from the .ibd files...

The most important error message is here:

2013-08-02 12:19:12 4536 [ERROR] InnoDB:
Attempted to open a previously opened tablespace.
Previous tablespace mysql/innodb_table_stats uses space ID: 1 at filepath: .\mysql\innodb_table_stats.ibd.
Cannot open tablespace xat/payments which uses space ID: 1 at filepath: .\xat\payments.ibd

The rest of the log:

InnoDB: Error: could not open single-table tablespace file .\xat\payments.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.

What is the cause of these errors and how can I rectify them?

Answer 1

IMPORTANT: do NOT delete ibdata1 file. You could destroy all your databases.

Instead, first try using the MySQL backup folder which is included with XAMPP. So do next steps:

1. Rename folder mysql/data to mysql/data_old
2. Make a copy of mysql/backup folder and name it as mysql/data
3. Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema, and phpmyadmin folders)
4. Copy mysql/data_old/ibdata1 file into mysql/data folder
5. Start MySQL from XAMPP control panel

And, voilà!

EDIT (January 7th 2023)

As mentioned by some users, this is an emergency solution, not a permanent one. After recovering your data is strongly recommended to back it up, and reinstalling XAMPP, because the failure is related to a malfunction from some of the files of XAMPP, not the databases.

Answer 2

IMPORTANT Deleting this file may render any existing MySQL data unusable. Use with caution

Hey I just did this and it worked:

1. exit Xampp server
2. go to your C:\xampp\mysql\data directory
3. delete the ibdata1 file
4. restart xampp server

It should work

Answer 3

Aug 2023

Disclaimer

Although many people said 'it worked' and very few say 'it didn't'.

It is hard to say what could be the cause and it is not working. Personally, the solution provided below worked for me and I didn't get any issues so far hence I am sharing this.

I don't suggest uninstalling, so you can basically back up the file and try this solution. If it doesn't work then place those files again.

Worked on other Versions

This issue works on other xampp versions too.
I have not tested personally, but some users have.
( If you have tested on a different version, let me know in the comment, I will add it here)

• XAMPP v8.1.6 - Saeid Z
• XAMPP v7.4.16 - CapelliC
• XAMPP v3.3.0 - Myself

Feb 2022 (Problem)

I had the same problem today (2 feb 2022).
I fixed this using the same solution I mentioned below (See Dec 2021 (Solution))

XAMPP Issue Screenshot

XAMPP Fixed

Dec 2021 (Solution)

Since this question is active continuously,
I will try my best to solve it.

My issue

I visit this post every time this issue happens. The only thing I tried was that I uninstalled xampp and reinstalled it, which fixed the problem. That was on my old system.

I am using windows 10 brand new with no unwanted software or issues, and I got this unexpected shutdown again after a long time. I came to this question, hoping someone would tell me actually what was going on instead of fixing these issues. But unfortunately, I could not find it.

Just to clarify, my new issue is not with

• port
• unexpected shutdown
• windows stuck
• unwanted software
• virus or malware.

One day I turned on xampp, and it stops working.

Method 1 (22 Dec 2021)

1. Stop MySQL.
2. Go to the C:/xampp/mysql directory and copy the data folder and keep it somewhere else (probably in another drive) as a backup.
3. Go to your original data folder (C:/xampp/mysql) and sort the files by 'Type.'
4. Select the files that have the type INFO File and delete them (screenshot below).
5. Start MySQL. It should work now.

Method 1 Screenshot

Important

Not necessarily the solution above will always fix the issue. Sometimes it will not. To avoid the major risk of losing the data, try these.

• Turn on MySQL in the Control Panel ONLY IF NEEDED.
• DO NOT set the XAMPP Control Panel to turn it on windows startup.
• Back up DB whenever possible. If not try to back up every weekend.
• Wait until Apache loads completely. When you turn on Apache it takes a few sec to load (indicated by the hour glass). Once it is loaded you turn on MySQL. - updated on Aug 2023

PS: I will try to update this answer whenever the above method(s) don't work. I will try to explain it in the simplest way possible without uninstalling XAMPP.

Let me know if it works for you.

Answer 4

If the answers mentioned above are not working, you can try deleting all the files in data, except for the folder

Go to the directory: C:\xampp\mysql\data and delete the following files:

After that, go to the directory C:\xampp\mysql\bin and open my.ini in a text editor. It will look like this:

Then delete comment out the port 3306 and change it to 8111. Then, run xampp with administrator privileges and it will work.

Answer 5

WORKING SOLUTION :- Follow the below listed steps.

Step 1. Rename the folder c:\xampp\mysql\data to c:\xampp\mysql\data_bkp (you can use any name).

Step 2. Create a new folder c:\xampp\mysql\data.

Step 3. Copy the content that resides in mysql\backup to the new mysql\data folder.

Step 4. Copy all your database folders that are in mysql\data_bkp to mysql\data (skipping the mysql, performance_schema, and phpmyadmin folders from mysql\data_bkp). IMPORTATN NOTE :- Please do not replace the existing files while pasting(click skip these files)

Step 5. Finally copy the ibdata1 file from mysql\data_bkp and replace it inside mysql\data folder.

Step 6. Start MySQL from XAMPP control panel.

And, Its DONE . 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.

Answer 6

1. Go to mysql/data/
2. Delete all random files (except the actual database folders)
3. Restart Apache and MySQL.

It should fix it.

Answer 7

Just follow two steps

1. go to xampp\mysql\backup copy everything from backup folder

2. go to xampp\mysql\data paste everything in data folder copied from backup folder

3. Thats all.

Also follow the video description to fix without losing any data:

https://www.youtube.com/watch?v=hB1wshpP3Jc

Or follow the article description to fix without losing any data:

https://webjourney.dev/error-mysql-shutdown-unexpectedly-solve-without-loosing-any-data-webjourney

Answer 8

UPDATE APRIL (2022)

1. Rename folder mysql/data to mysql/data_old
2. Make a copy of mysql/backup folder and name it as mysql/data
3. Copy all your database folders and mysql folder from mysql/data_old into mysql/data
4. Copy mysql/data_old/ibdata1 file into mysql/data folder

Start MySQL from XAMPP control panel

REFERENCE

https://www.youtube.com/watch?v=ipMedkjMupw&ab_channel=GeekyScript

Answer 9

When you're not running XAMPP as an administrator, shutting down MySQL frequently causes corruption which means you have to repair or delete your tables. To avoid this you need to either run XAMPP as an administrator, or use the proper command prompt method for shutting down MySQL.

You can delete ibdata1 as Kratos suggests, but this can leave you with a broken database as other pieces of your database are still in the /mysql/data/ folder. In my case, this residual data stopped me successfully installing WordPress.

A cleaner way of undoing the damage is to revert your whole /mysql/data/ folder. Windows has built-in folder versioning — right click on /mysql/data/ and select Restore previous versions. You can then delete the current contents of the folder and replace it with the older version's contents.

Addendum: To ensure that you don't forget to run XAMPP as an administrator you can right click the XAMPP shortcut, go to Properties, then Advanced, and finally tick Run as administrator.

Answer 10

I got the same kind of error in my C:\xampp\mysql\data\mysql_error.log when trying to start mysql.

2013-08-05 01:20:32 6780 [ERROR] InnoDB: Attempted to open a previously 
  opened tablespace. Previous tablespace mysql/slave_relay_log_info uses 
  space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open  
  tablespace test_database/test_table which uses space ID: 3 at filepath:  
  .\test_database\test_table.ibd

You'll have to read the error closely. This says that test_database is preventing mysql from starting.

You could blow away the offending database, these steps fix the problem:

1. Make sure mysql and xampp is shut down completely.
2. Go to your directory where mysql is installed, mine is: C:\xampp\mysql\data
3. You should see a folder with the name of a database that you created. mine was test_database.
4. Create a new folder somewhere else called C:\xampp\mysql\data\mysql\backuptablespace
5. Drag and drop (don't delete) the offending database table folder to the backup directory.
6. Try to start mysql again. For me it started right up in 1 second as expected.

If it doesn't work, put the file back where you started and you'll be back where you started.

If you don't want to delete the database and don't have backups:

If you don't have backups of table data and mysql won't start because something is corrupted you'll have to use the process of elimination to guess-and-check your way to exactly what you did that corrupted it. Follow these steps:

1. Make a clone of the entire C:\xampp\ and store it somewhere safe so you can get back to where you started.
2. Use a "binary search" approach to try to locate the corrupted item in the mysql database. It could be a file, or a table, or a database, or a user or anything.
3. Delete the entire database and see if that allows mysql to start. If it does, then put back the database and try removing some of the tables. If it doesn't, then try yanking out something else until it does start.

4. Try removing these files from C:\xampp\mysql\data\mysql: db.frm db.MRD db.MYI db.opt user.frm user.MYD user.MYI

5. When you get mysql to start, try putting things back until you find the one thing that you add which prevents it from starting. One bonus for this is you learn how mysql works under the hood.

Nuclear option:

Something you did screwed up the mysql server. An uninstall and reinstall of XAMPP should undo the corruption.

Answer 11

Simple solution Open shell from Xampp Control Panel

mysqld --console --skip-grant-tables --skip-external-locking

Then again open an other shell and run

mysqlcheck -r --databases mysql --use-frm

Now close both shells and restart the xampp.

Answer 12

Add the following line below the [mysqld] section in the mysql config file (my.ini) and restart the apache web server and the mysql service afterwards.

[mysqld]
innodb_force_recovery = 4

Answer 13

Step 1 : Close Xampp controller completely
Step 2 : Open C:\xampp\mysql\backup
Step 3 : Copy all the files from backup folder
Step 4 : Open C:\xampp\mysql\data
Step 5 : Paste the all the files in data folder
Step 6 : Re-start the Xampp controller

Answer 14

My Xampp MySQL worked just follows as below:

01.Go to mysql/data/ directory
02. delete the ibdata1 & ib_logfile*(ib_logfile0,ib_logfile1,ib_logfile101) file
03. restart xampp server

Answer 15

Never delete this file (ibdata1) because all your data will be deleted!!!
I suggest three ways :

A:
1- Exit from XAMPP control panel.
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 (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
5- Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
6- Reastart your system.

B:
1- Stop all sql services.
2- Next, start all sql services again.

C:
1- Open XAMPP control panel
2- Click on Config button, in front of mysql, click on my.ini



3- change client port and server port.

Answer 16

I have tried all the above answers but it didn't work for me. So finally I tried the below approach and it works 100% for me.

If you are worried about following the below steps you can take a backup of the entire XAMPP folder for the safe side.

Step 1: Rename the c:\xampp\mysql\data folder to c:\xampp\mysql\data_bkp

Step 2: Create a new folder c:\xampp\mysql\data.

Step 3: Copy the content, that is present inside c:\xampp\mysql\backup to the new c:\xampp\mysql\data folder.

Step 4: Copy all your database folders c:\xampp\mysql\data_bkp to c:\xampp\mysql\data (Note: Don't copy mysql, performance_schema, and phpmyadmin folders).

Step 5: Copy the ibdata1 file from c:\xampp\mysql\data_bkp and replace it inside the c:\xampp\mysql\data folder.

Step 6: Start MySQL from the XAMPP control panel.

Answer 17

I also faced this issue and this is how I solved.
1. Make sure xampp is not under sub-directory. For example, it should be C:\xampp
2. You might need to run as administrator in running the application.

Hope this will work!

Answer 18

1. move xampp/mysql/backup files into xampp/mysql/data
2. RUN XAMPP as Administrator(make sure mysql is installed you can see a green tick if is installed)

Hope it helps!

Answer 19

STOP! Please do NOT delete ibdata1 file!

Deleting this file is like playing Russian roulette with your databases, it could work and re-establish everything, but also, it could leave every database you have unusable.

Instead, first try using the MySQL backup folder which is included with XAMPP. So do the next:

• 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 (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)

Finally:

• copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
• Start MySQL from XAMPP control panel

Answer 20

in my case i did following steps and it worked:

1. In Xampp control panel click on "Services" button from the right side toolbar

2. Then find "MySQL" from the services List

3. Click on it and from the left side of the panel click on "stop"

4. Turn back in Xampp control panel and click on start.

Answer 21

1. Close Xampp
2. Open that folder
3. Select only the files not the folders in that Dir
4. Delete only the files, including those that are cached.
5. Open Xampp and start.

Answer 22

Here is what I did. I restarted my computer. Next I run services.msc. I stopped the MySQL service then restarted it. The restarted the Xampp server.

Answer 23

I have resolved the problem by ending the task for mysqlid on Task Manager.

Answer 24

Here is the way you can solve this problem:

1. Go to C:\xampp\mysql\data
2. You will see a folder named as mysql/data
3. Rename that folder from mysql/data to something else like mysql/data_not_useful any name that you want to give.
4. Create a new folder named as mysql/data.
5. Copy all the files of the mysql/backup and paste in mysql/data.
6. Now go to mysql/data_not_useful and copy the file ibdata1 from there.
7. Then paste it in mysql/data (You have to replace the file).
8. Restart your xampp server.
9. Now run your mysql server.

Answer 25

Go to xampp/mysql/data

1. Rename folder from data to data_backup
2. Create new folder data
3. Copy files from backup to data
4. delete ibdata1 from data folder
5. Copy ibdata1 from data_backup folder to data folder
6. Copy your all database from data_backup to data folder
7. Restart xampp. It will start working

Answer 26

No solution above worked for me. then I did below:

I deleted all the files inside C:\xampp\mysql\data\ directory except folders in this directory. It worked perfectly fine but my previous databases are not working now. So do above if you don't care it will delete all your previous databases in phpmyadmin.

Answer 27

i was facing the same issue and none of the solutions stated above helped me. i went to the mysql configuration file (my.ini) and changed the port number under [mysqld].By default mysql runs on 3306 port.

port= 3306

i changed it to ,

port= 8111

Then run as Administrator.Finally this worked for me.

Answer 28

This means that you already have a MySQL database running at port 3306.

In the XAMPP control panel, press the 'Config' button and after that press 'my.ini'. After this, Ctrl-F and search for '3306'. Replace any '3306' that you find with a different port number of your choice (you could choose 3307 or 3308 - I chose 2811 and it worked).

After you have replaced every location where '3306' is written, save the file and press 'Start' on the control panel again.

Answer 29

1. Copy all files from xampp/mysql/backup/ then paste into /xampp/mysql/data/
2. Restart mysql.

Answer 30

Had the same issue.

STAEP 1

backup folder xampp/mysql/data (saved it as `xampp/mysql/_old_data`).

STAEP 2

Go to xampp/mysql/data and deleted all the files but not folders! With databases.

STAEP 3

At this stage your database will not work. You need to go to your backup folder `xampp/mysql/_old_data` and copy over "`ibdata1`" file to `xampp/mysql/data`.

After that everything work as expected including phpmyadmin and console.

STAEP 4

If this does not help. You can remove xampp/mysql/data folder and rename xampp/mysql/_old_data back to xampp/mysql/data. (ROLLBACK) and try different things.

Answer 31

Xampp stop Instantly after start.

copy all files and folder from C:\xampp\mysql\backup and paste into C:\xampp\mysql\data.

Answer 32

0.cntr+alt+delet
1.end task mysqld
2.Restart mysql.

Answer 33

I solved similar MySQL error & I think this answer will help you to fix the same type of MySQL database error.

Solution:

• Go to the “data” directory in the mysql database.
• I installed XAMPP on D: drive on my computer & the mysql “data” directory location of my computer was “D:\xampp\mysql\data\”. You may have different location.

Take Backup of MySQL “data” Folder

• First of all you should create a backup of the “data” folder using any compression software.

• Give a name like “data_backup.zip” or any type of compression you wish.

• I used winrar compression software to compress & backup mysql “data” folder.

Rename the “data” folder

• Rename the “data” folder to “data-oldfiles”. This is very important to rename the data directory to any new directory name.

Create a new “data” folder

• Create a new folder and give the folder name as “data“
• To solve the problem we need to create a new “data” directory in the mysql database.

Copy content from “backup” folder

• Go to the “backup” folder and copy all files.
• Paste the files from backup folder to data folder
• Now start the MySQL database from XAMPP.
• Your MySQL database will start properly without showing any error.

Transfer all MySQL projects Database, Data file & Log files

• If you have many database which was used for various projects, then you have to transfer all database from “data-oldfiles” folder to “data” folder.

• Copy all databases from the data-old files and paste to the data folder.

• Now you have to copy the data file “ibdata1” & all log files “ib_logfile0, ib_logfile1 ” from data-old files folder to the data folder.

• If you have many id_logiles then copied all of them.

• Now Start MySQL from XAMPP.

• Go to phpMyAdmin to check all databases are available & working.

• Now start your any website project from localhost to check the MySQL database.

The Problem is solved !!

• Now you will see the problem is solved and the error message “Error: MySQL shutdown unexpectedly.” will not show again.
• If you have any question on this issue please feel free to ask any question in the comments section.

You can read the details tutorials on the link bellow: Error: MySQL shutdown unexpectedly – Solution in 5 easy steps

You can also watch video tutorials to solve the problem:

[Solved] Error: MySQL shutdown unexpectedly

Answer 34

go to : c: C:\xampp\mysql

Rename the folder "data" to "data_old" (you can use any name) Create a new folder "data" Copy the content of "backup" folder to the new "data" folder. Copy all content of "data_old" to "data" (skip those folder "mysql", "performance_schema", and "phpmyadmin") *** without remplacing the file in the destination (skip theses files)**

restart XAMPP and it will works

Answer 35

I also get the same issue. Solution was kill process Find the PID for port (3306)

netstat -a -n -o | find "3306"

You will see everything you need.

0.0.0.0:3306           0.0.0.0:0              LISTENING       8120   TCP    
0.0.0.0:33060          0.0.0.0:0              LISTENING       8120   TCP    
[::]:3306              [::]:0                 LISTENING  8120   TCP    
[::]:33060             [::]:0                 LISTENING  8120

PID is 8120

Next run the following command

taskkill /PID 8120 /F

Start MySQL again. It will be fine. Happy cording.

Answer 36

if you are using MariaDB you can try this:

1. Go to mysql/data/
2. Rename aria_log_control to aria_log_control_old
3. Restart "Mysql"

Answer 37

Guys just make sure you dont have MySql Server installed. Because I have MySql server pre-installed and when I start mysql from xampp control panel some port conflicts are happening and its not working.. SO before starting the mysql from xampp control panel make sure mysql server is not installed. I use .net so I have installed mysql server in the Past. Uninstalling it solved my Problem....

Answer 38

What worked for me is (No File Delete):

1. First I open Logs for MySql in XAMPP panel.
2. At the end it says you are running another instance of mysqlid in port 3306
3. I opened my task manager(Ctrl+Shift+Esc) then find mysqlid and End the task.

Answer 39

I had encountered the same issue, but all I had to do was close the XAMPP Control panel, go to the folder in which XAMPP is installed, find xampp-control.exe and run as administrator and then start the services.

Answer 40

# The MySQL server
default-character-set=utf8mb4
[mysqld]
skip-grant-tables // Place this line here 
port=3306
socket="C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"
pid_file="mysql.pid"
# enable-named-pipe
key_buffer=16M
max_allowed_packet=1M
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K

Open my.ini file from C:\xampp\mysql\data

skip-grant-tables place this line before port and restart and it working

Answer 41

follow these steps:-

1. Go into C:\xampp\mysql

2. Rename data folder by data_old

3. Create a new folder empty data folder

4. Copy all files from data_old and paste them into the data folder

5. Copy all files from the backup folder and paste them in the data folder and replace all files

6. Copy ibdata1 files from data_old and paste and replace them in the data folder.

7. Restart Server

All the best!!

Answer 42

Try the following solutions to fix the issue. Before performing this process, rename the data folder C:\xampp\mysql\data to the old_data. Then create a new folder named data in the SQL folder. Copy all the files and folders in the backup C:\xampp\mysql\backup folder into the data folder. In the last step, copy the ibdata1 file and the test folder from the old_data folder and put it in the data folder. Run the program now and enjoy!

Answer 43

I had the same problem. My xampp controll panel will start apache but not mysql. The problem is in iblogfile. This happens when you are running xampp/mysql and your pc restarts without properly shutting down the innodb engine. Goto xampp/mysql and delete

ib_logfile0

and

ib_logfile1

Now restart mysql and it should work.

Answer 44

Temporary Solution;

delete the aria_log_control file. You can find it on C:\xampp\mysql\data(my path is like this). Then restart MySQL.

I saw this solution on the internet but I don't remember the source.

Answer 45

In my case in which I synced my mysql data and htdocs to dropbox, I just needed to delete the conflicted files in mysql/data folder and subfolders. The conflicted files can be identified by its names, dropbox will tell you that. It has solved the problem for me.

Answer 46

For me I quit Skype, which was occupying port 80, then Apache ran happily on port 80, than I ran Skype and it picked another port this time.

Answer 47

Make sure the system time is correct. Mine was set to the year 2040 somehow, correcting the date solved the problem.

Answer 48

i comment this statement in mysql/bin/my.ini

'innodb_additional_mem_pool_size=2M'

and it solve my problem. than you everyOne

Answer 49

For me, the problem was:

I used to hibernate my PC instead of shutting down due to the scale of the project. I was lazy enough to reopen all programs.

Before trying anything else, I recommend you to do the following simple things. Otherwise, you will be messed up your MySQL server.

1. Open your task manager and End the XAMPP process.
2. Re-run the XAMPP application as Administrator.

If not works,

1. Save all unsaved programs and restart the PC.
2. Run XAMMP as administrator.

Also, make sure to check 3306 & 5040 ports. These two ports are required to run MySQL on default settings.

Check @Ryan Williams answer to find of why it's good to run XAMPP as administrator.

Answer 50

I literally deleted every file from c:\xampp\mysql\data\ except my.ini and it works

Answer 51

first of all, make a backup file of your database C:\xampp\mysql\data copy this file and past it somewhere in your pc. After this open, the data file and also open the XAMPP server try to delete the files step by step one by one after deleting each file try to run the MySQL server after deleting a single file as shown in the screenshot thus your databases won't delete. if the file deletion does not work then try to copy the same files from the backup folders and repeat this until it works... this is time taking but this worked for me I have solved this in 20 minutes.

Answer 52

Go to C:\xampp\mysql\backup.

Copy all files.

Paste them into C:\xampp\mysql\data.

If Windows asks you to replace some files, replace them.

If your XAMPP Control Panes is active close it.

Go to C:\xampp and find xampp-control, run it.

Start Apache, start MySQL.

---

That's it.

Enjoy!

Answer 53

Error: MySQL shutdown unexpectedly

This is the best answer 

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 (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
5)Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
6)Start MySQL from XAMPP control panel

Answer 54

I faced the same issue. MySQL stops as soon as I turn it on.

In the logs it said:-

10:31:21 [mysql] Problem detected! 10:31:21 [mysql] Port 3306 in use by "Unable to open process"! 10:31:21 [mysql] MySQL WILL NOT start without the configured ports free!
10:31:21 [mysql] You need to uninstall/disable/reconfigure the blocking application
10:31:21 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

I stopped the running service on port 3306 wamp(in my case), and it worked fine after that. Changing the port in config settings should also work.

YW!

Answer 55

Simple solution

Rename below files in xampp\mysql\data folder

 ib_logfile0
 ib_logfile1

Or any such logfiles to

 ib_logfile0.bak
 ib_logfile1.bak

And now start mysql from xampp control.

Answer 56

None of the solutions above are not working. It's working only temporarily. After a few days, we are facing the same issue again & again. I've lost all of my DBs on each and every time.

I don't know the exact solution. But, I am doing the 3 simple steps again & again.

1. Rename the folder c:\xampp\mysql\data to c:\xampp\mysql\data_old (you can use any name).
2. Create a new "data" folder c:\xampp\mysql\data
3. Copy all your database folders that are in mysql\data_old to mysql\data

then Start MySQL from the XAMPP control panel.

SOLVED!: I solved it using this method:

Open shell from from control panel and start mysql with this command:

mysqld –-console –-skip-grant-tables –-skip-external-locking

Open another shell from the control panel and repair the database with this command:

mysqlcheck -r --databases mysql --use-frm

Stop mysql, close shells, and restart mysql normally.

Refer: https://stackoverflow.com/a/60576807/1662058

Answer 57

I open and empty the file multi-master.info which exists in data folder. this worked for me.

Answer 58

For this, you need to click on the x option under Modules Services and make MYSQL services installed. Then start the services. Here you go.

Answer 59

If the crash message is "mysql.exe has stopped working". Just run xampp-control.exe as administrator will solve your problem instantly.

Answer 60

If any of the things above do not work, make a back of Xampp directory and reinstall Xampp. That surely works!

Answer 61

Rename below files from mysql/data ib_logfile0 ib_logfile1 ibdata1

my.cnf innodb_buffer_pool_size to 200M as per your ram innodb_log_buffer_size to 32M

Restart your apache server

hope it helps you

Answer 62

I solved! deactivate UAC with msconfig before to install xampp

Answer 63

That's the more precise answer and worked for me!!!! ! A cleaner way of undoing the damage is to revert your whole /mysql/data/ folder. Windows has built-in folder versioning — right click on /mysql/data/ and select Restore previous versions. You can then delete the current contents of the folder and replace it with the older version's contents. as mentioned above by Ryan Williams.

Answer 64

Go to task manager And search mysqld and right click and select END TASK and refresh XAMPP

Answer 65

Create a Back up your mysql folder from C:\xampp\mysql. Then go to C:\xampp\mysql\backup Copy all the files and paste it into C:\xampp\mysql\data.

Then from your old backup folder see for ibdata1 file you can find it in C:\xampp\mysql\data. Copy this file and paste in into C:\xampp\mysql\data.

Now restart xampp and it should work.

Answer 66

There are a number of things I've tried. This is the 2nd time this has happened to me. On my first time, I've to reinstall my xampp. And on the third day, mysql crashed again. I've tried everything I found on the internet. Like, innodb_flush_method=normal in my.ini file and deleting ibdata1, ib_logfile1, ib_logfile0 files, and others but none of these works. So later I tried to run xampp with admin privilege and install apache and mysql as a service as it was instructed on xampp control panel itself. After starting mysql, I read error-log again and from there I came to know that one of my databases is responsible for this. That database file won't let mysql start. So I deleted everything in the data folder and then in cmd I navigated to C:/xampp/mysql/bin path and ran these commands:

mysqld --initialize

mysql_install_db

and mysql started running again. But my databases and data are lost.

Answer 67

If none of the solutions listed here didn't work for you just like me, then

1. Go to your task manager.
2. Go to the Services tab.
3. Find Service named "MySQL80".
4. Right-click on it and select "stop".
5. Go back to XAMPP control panel and start the MySQL service.

It worked for me.

Answer 68

If none of the deletion of files work then probably your mysql service is not running. Go to services.msc and start mysql service

Answer 69

I also had this problem when i get this error , go xampp->mysql->data then delete all other files without folder , do not delete folders , then run xampp and start mysql

Answer 70

If you do not need data in the corrupt table, you can drop it by first discarding the tablespace:

ALTER TABLE sakila.actor DISCARD TABLESPACE;

after that you can drop the table itself:

DROP TABLE sakila.actor;

In case the first step is not working, first replace actor.ibd file with a copy from an empty table with the same structure.

Source

Answer 71

Remember Never delete this file (ibdata1) because all your data will be deleted

1- stop all running xampp services ( apache,mysql,..etc)

2- rename xampp folder to xampp-old

3- install fresh xampp

4- Restore Databases by copy these 3 files (ibdata1,ib_logfile0,ib_logfile1) + your database folders you created from xampp-old from this path

xampp-old\mysql\data

to

xampp\mysql\data

and accept replace files

5- Restore coded files by transfer xampp-old\htdocs to xampp\htdocs

now start xampp , it will work with all of your data

note: if you need to edit appache or mysql ini do this again

Answer 72

Step 01 : If you have an Error with starting XAMPP MySQL, Follow These Steps To Easy Solving This Problem.

Step 02 : Stop the Server and go to Config.

Step 03: Open this my.ini file.

Step 04: Find These 2 Port numbers in your notepad text.

Step 05: Change these 2 port numbers 3306 --> 3308 or any other number.

After Save the text file using Ctrl+S

Step 07 : Go to your XAMPP installation Folder and open XAMPP Folder. Step 08 : Find phpMyAdmin folder.

Step 09: Open the phpMyAdmin Folder and Find config.inc.php file.

Step 10: Change Here Port number that previous you Change in Step 05. (Like 3008) and Save This Text File.

Step 11: After Close all Files and Go to your XAMPP Server.

Step 12: Start again MySQL Server.

Step 13: Open Your Web Browser and Type in URL -->> localhost Step 14: Go to PhpMyAdmin

Step 15: phpMyAdmin is Working properly Now.

if you have any Error in Starting Apache Server,

Step 01 : Stop The Server, and Open Config File.

Step 02: Find this Listen number in your text file.

Step 03: Change that 80 to 8000 or any other value. and save text file.

Step 04: After saving text file, Open your XAMPP Server and Start Apache Server Again.

Step 05: After Open your web browser. Step 06: Type localhost:8000

Step 07: Now you Can Open Your phpMyAdmin.

Note : After Changing Apache port number, You Must add in to that after the localhost: in your URL.

-----------Thank You Guys-----------

Answer 73

You are getting this error because , your sql port 3306 is busy ( other app is using it )

stop the process of 3306 ( by closing that app end process ) but how to find that?? download the tcp viewer of microsoft open the app and search for sql you will see the sql is running and using 3306 port that why the xampp's mysql is unable to run..

just end the process the myql and you are good to go start the mysql of xampp and done

Answer 74

Go to task manager and end your running MySQL task and restart your MySQL in XAMPP

Answer 75

This happened when you already use the 3306 port. Just change the server port and it would be fixed.

Answer 76

Open config file of MuSQL in Xamp and change port number to 3307 It worked for me :)

Answer 77

first go to config from control panel

then edit the port of mysql to 8111

then go to : my.ini file at C:\xampp\mysql\bin

and make the port from 3306 to 8111 then save

and go to control panel and stop the apache
then try to turn it on again with my sql it will work with me

Answer 78

If you have this issue and you are using XAMPP then before deleting/moving/renaming any file or folder, just open Task Manager and search for XAMPP and if you find any rows just end this task.

Now open XAMPP again and try to start sql.

Answer 79

Config->Apache->Open httpd.conf. search for Listen or 80,update listen port to 8081 save and restart server. Oh and shutdown Skype if you have it.

Answer 80

Fixed it by reinstalling the Xampp.

If you don't want to go through all the technical stuff that the other proposes.

Back up the htdocs folder then uninstall Xampp, it will ask you if you want to retain the htdocs folder, opt-out. Completely uninstall, remove the remains. The install again, copy back your backed-up htdocs folder.

you're done.

Answer 81

Solve in 10 Seconds

1. Go to mySql folder inside your xampp folder
2. rename data folder as data-old
3. create new folder name it as data
4. copy all the contents of the backup folder into new data folder...

You are good to go

Answer 82

this PowerShell script automated the solution for you:

Rename-Item -Path "./data" -NewName "./data_old"

# Create new data directory
Copy-Item -Path "./backup" -Destination "./data" -Recurse
Remove-Item "./data/test" -Recurse
$dbPaths = Get-ChildItem -Path "./data_old" -Exclude ('mysql', 'performance_schema', 'phpmyadmin') -Recurse -Directory
Copy-Item -Path $dbPaths.FullName -Destination "./data" -Recurse
Copy-Item -Path "./data_old/ibdata1" -Destination "./data/ibdata1"

# Notify user
Write-Host "Finished repairing MySQL data"
Write-Host "Previous data is located at ./data_old"

https://gist.github.com/josemmo/24e35f2b4984a4370ce2c164f5956437