Linux

Unable to start MySQL service: Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed

MySQL server fails to start. The following error message is shown in the MySQL error log file:

 

For Linux :

  1. Add the following string into the configuration file /etc/my.cnf:

  2. In the same my.ini file change the InnoDB log file size to the value mentioned in the error message. In the current example it is required to change the InnoDB log file size to 5242880 bytes:

  3. Rename files ib_logfile0 and ib_logfile1:

  4. Start mysql service:

  5. If it did not help, backup all ib_logfile* files in /var/lib/mysql directory and remove original ones (all of ib_logfile* files).

Tui là jamesblackvn!

Gửi phản hồi

Website này sử dụng Akismet để hạn chế spam. Tìm hiểu bình luận của bạn được duyệt như thế nào.