I got the below error while restarting mysql service after updating the my.cnf file :
[ERROR] Plugin ‘InnoDB’ init function returned error. [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. [ERROR] Unknown/unsupported storage engine: INNODB [ERROR] Aborting
Just followed the below steps to resolve the issue :
cd /var/lib/mysql mv ibdata1 ib_logfile0 ib_logfile1 /tmp/
Note that my datadir was /var/lib/mysql. Change the location accordingly.
service mysqld restart
[root@theg-01 mysql]# service mysqld restart Stopping mysqld: [ OK ] Starting mysqld: [ OK ]
Thats it 🙂