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!