After playing around with my MySQL configuration file in my docker container, MySQL was throwing a weird error, and was failing to start.
I checked the error logs and found an entry in the error log.
[ERROR] Plugin ‘InnoDB’ init function returned error.
[ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported storage engine: InnoDB
After googling and searching SO for a while, I realised that the solution is to rename or delete some of the log files of InnoDB. In case you are concerned about the data, it would be wise to have a backup of those files, in my case I encountered the error on a fresh docker MariaDB container. Hence I chose to remove the files.
and then restart MySQL.
root@docker# /etc/init.d/mysql start
Starting MySQL database server: mysqld . ..
Checking for tables which need an upgrade, are corrupt or were
not closed cleanly..
And thats it, I now have my MySQL server up and running once again.