Showing posts with label XAMPP MySQL Troubleshooting. Show all posts
Showing posts with label XAMPP MySQL Troubleshooting. Show all posts

Get Your XAMPP Running Again: Fixing the 'MySQL shutdown unexpectedly' Error

 
Totally stopped the MYSQL running. I restart the xampp server many times but doesn’t work. I don’t know what happened on XAMPP Server.
Finally i found the solution. the problem is MYSQL shutdown unexpectedly.
Solution is,

      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.

Only by looking at the logs, we can find the exact issue. Hope this helps.

Thank You !!!