XAMPP MySQL fails to start: ‘InnoDB’ ENGINE failed

MySQL fails to start
MySQL fails to start

Some times MySQL fails to start/restart with an error like “Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed”

The simple solution to fix is to delete InnoDB log files “ib_logfile0” and “ib_logfile1“.


Steps to delete above mentioned files

  • The files “ib_logfile0” and “ib_logfile1” usually reside in the data directory in Mysql installed directory so delete those files with the following commands.
sudo rm /usr/local/mysql/data/ib_logfile0 /usr/local/mysql/data/ib_logfile1
  • Then start/restart MySQL service again and it should start working.
// MAC users
sudo /usr/local/mysql/support-files/mysql.server start
sudo /usr/local/mysql/support-files/mysql.server restart

Note: Mysql Directory path

  • The above paths mentioned may vary on different systems but below paths are general installation paths on most of the systems:
    • For Window:
      [drive]:\ProgramData\MySQL\MySQL Server 5.5\data
      C:\ProgramData\MySQL\MySQL Server 5.5\data\ib_logfile1
    • For mac:
      /usr/local/mysql/data

References

I hope it helps you resolve your problem.


Related Posts

Visit https://techtalkbook.com to find more related topics.

Happy Coding!!!


About the Author

Sandeep Agrawal
working @ Kalpavruksh Technologies as Software Engineer. I am a simple and straightforward person adaptable to any environment and work culture. Like to work in a creative and challenging environment using cutting edge technologies where I could constantly learn and successfully deliver solutions to problems.

Be the first to comment on "XAMPP MySQL fails to start: ‘InnoDB’ ENGINE failed"

Leave a comment

Your email address will not be published.


*


0 Shares
Tweet
Pin
Share
Share
Share
%d bloggers like this: