Developers often encounter the error message "[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed" when performing website migrations or making configuration adjustments.
Problem Statement
MySQL service is stopped.
Error Message
150206 4:42:12 [ERROR] Plugin 'InnoDB' init function returned error.
150206 4:42:12 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150206 4:42:12 [ERROR] /usr/sbin/mysqld: unknown variable 'local-inline=0'
150206 4:42:12 [ERROR] Aborting
Solution 1
We fixed this error by modifying /etc/my.cnf file and removing the statement "local-inline=0".
Solution 2
One of the common possible causes of this error is my.cnf file has been modified and saved with an incorrect structure.
- Login to the server via SSH with root access. Please refer to how to connect VPS via SSH for more details.
- Navigate to /var/lib/mysql.
- If you see log files like ib_logfile0 and ib_logfile1, rename or move them to some other folder.
- Stop and start the MySQL service.
→ Any other issue with MySQL? Do not forget to take a look at our other informative articles on MySQL.
