October 08, 2021

How to Fix MySQL Error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed"

Solving MySQL Error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed"?

Had this error creep up after restoring a VM from backup and changing the machine name. I did a quick search and stumbled upon a whole slew of solutions that did not work until I finally saw this article and found that the second solution it offers worked for me.

It a very simple solution to what I thought was going to be a huge headache. Here it is:

  • Navigate to your SQL server data folder.
    • This is the typical Redhat/CentOS path /var/lib/mysql for those with similar systems.
  • Look for these log files named like, ib_logfile0 and ib_logfile1
    • All you need to do is rename or move those log files  to some other folder.
      • Stop and start the MySQL service
        • Tadaaa! It worked for me. MySQL server started humming along as expected again.


        Original solution article link: Click here for it.



        Share:

        0 comments:

        Post a Comment