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 : Julian's | 80 views