Getting error “Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed” when starting MySQL

Check error : /var/run/mysqld/mysqld.err

Jika pesan error : Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed

Solusi :

  • Login to server via SSH with root access.
  • Navigate to /var/lib/mysql.
  • If you see log files like, ib_logfile0 and ib_logfile1, rename or move them to some other folder.
  • Stop and start the MySQL service by running sudo service mysql stop and sudo service mysql start

atau bisa menggunakan :

Moving ib_logfile0 and ib_logfile1 files didn’t help either.

What did help was:

> service mysql stop
Edit my.cfg and add innodb_force_recovery = 1

> service mysql start
> service mysql stop
Comment the innodb_force_recovery = 1 line.

> service mysql start

Posted on: August 27, 2022, by :  | 13 views