Error: MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies, 11:20:52 AM [mysql] improper privileges, a crash, or a shutdown by another method. code example
Example 1: xampp mysql shutdown unexpectedly
1. Exit Xampp and navigate to xampp/mysql/data directory
2. delete the ibdata1 file
3. restart the XAMPP server
or
1. Exit Xampp and navigate to xampp/mysql/data directory
2. delete the ibdata1, ib_logfile0,ib_logfile1,ib_logfile101 files
3. restart the XAMPP server
or
Try to check the error log at the installed location: /xampp/mysql/data/mysql_error.log
This can help you better debug the problem.
Also Note:
1. XAMPP might hit into port issue when you have skype also running.
2. There is a federated plugin issue that is common.
Example 2: Error: MySQL shutdown unexpectedly.
go to Xampp and navigate to xampp/mysql/data directory
delete all files and dir
and paste files in backup directory