XAMPP - Error: MySQL shutdown unexpectedly
First you need to keep copy of following somewhere in your hard disk.
C:\xampp\mysql\backup
C:\xampp\mysql\data
After that
Copy every thing inside "C:\xampp\mysql\backup" and paste and replace it in
"C:\xampp\mysql\data"
Now your mysql will work in phpmyadmin but your tables will show "Table not found in engine"
For this you will have to go to the copy of "backup and data folders" which have created in your hard disk and there in the data folder copy "ibdata1" file and past and replace in the "C:\xampp\mysql\data".
Now your tables data will be available.
Make sure you backup the mentioned folders before taking any action!
This worked for me,
- Quit the XAMPP
- Cut all files in C:\xampp\mysql\backup
- Paste and replace files into C:\xampp\mysql\data
- Run the XAMPP as administrator
In my case, I did two things:
- moved
xampp/mysql/backup
files intoxampp/mysql/data
- RUN XAMPP as Administrator
It worked for me :)
If your skype is open, Quit skype and try,
or
Go to your xampp/wamp installed, search for httpd.conf. Open that file using textpad/notepad, search for Listen or 80 , update listen port to 8081 and save the file. Restart xampp/wamp, start the servers.
or
follow below steps in skype