Solve MySQL: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Problem

Initially I started mysql with incorrect and ran into error in the error log.

141005 12:00:00 [ERROR] Plugin 'InnoDB' init function returned error.
141005 12:00:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141005 12:00:00 [ERROR] Unknown/unsupported storage engine: INNODB
141005 12:00:00 [ERROR] Aborting

141005 12:00:00 [Note] /usr/sbin/mysqld: Shutdown complete

141005 12:00:00 mysqld_safe mysqld from pid file /local/mysql/data/mysqld.pid ended

Solution

Go to the data directory and remove log files look like ib_logfile0, ib_logfile1 and ib_logfile2. Then start mysql, this fixed the issue.

$ sudo service mysql stop
$ sudo rm /var/lib/mysql/ib_logfile[0]
$ sudo service mysql start # Starting MySQL ... SUCCESS!
0.00 avg. rating (0% score) - 0 votes