XAMPP – MySQL shutdown unexpectedly

 
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 !!!

1 comment:

  1. I admire this article for the well-researched content and excellent wording about Xampp. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. how to change port number in xampp server

    ReplyDelete

If you have any doubts regarding the post. Please let me know.