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 :  | 58 views
https://serang.ut.ac.id/css/css/slot88/ https://tinjut.bagkeu.dikdasmen.kemdikbud.go.id/slot-maxwin/ https://dpm.polinema.ac.id/slot-gacor/ https://akademik.ft.unm.ac.id/slot-dana/ https://ppdb.probolinggokab.go.id/slot-5000/ https://bkad.sulselprov.go.id/assets/ https://ojs.balidwipa.ac.id/docs/slot-gacor/ http://korpri.pekalongankab.go.id/api/slot-gacor/ https://elang.umpp.ac.id/foto/farmasi/-/asset/ http://rsud-kelet.jatengprov.go.id/wp-content/-/asset/ https://kusdhianto-fe.staff.ugm.ac.id/slot88/ http://ppdb.probolinggokab.go.id/judi-bola/ https://bapenda.labuhanbatukab.go.id/racikan-sbobet/ http://rsud-kelet.jatengprov.go.id/wp-content/-/data/ https://agenda.riau.go.id/-/judi-bola/ https://balapan.padang.go.id/sbobet88/ http://jdih.wakatobikab.go.id/sbobet88/ http://kph.menlhk.go.id/sbobet88/ https://bkad.sulselprov.go.id/data/ https://dpm.polinema.ac.id/slot-gacor/ https://dinkes.jemberkab.go.id/storage/attachments/