How to Fix MySQL Error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed"?

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 incorrect structure.

  1. Login to server via SSH with root access. Please refer to how to connect VPS via SSH for more details.

  2. Navigate to /var/lib/mysql.

  3. If you see log files like, ib_logfile0 and ib_logfile1, rename or move them to some other folder.

  4. Stop and start the MySQL service.

→ Any other issue with MySQL? Do not forget to take a look at our other interesting articles on MySQL.

Related Articles

How to check MYSQL Database size in phpMyAdmin and via command?

Sometimes it is required to check the MySQL Database size. You can check it from the phpMyAdmin...

How to back up MySQL databases using AutoMySQLBackup?

What is AutoMySQLBackup? AutoMySQLBackup is a script that allows you to schedule the automatic...

How to Repair a MySQL Database Through Linux and Windows Command Line?

This article describes how to repair MySQL database tables through Linux and Windows command...

How to Fix MySQL Error "The server quit without updating PID file"?

MySQL server plays a vital role for your Linux Server. It runs all of your website's databases,...

How to take a Backup and Restore of MySQL Databases via Command Line?

mysqldump is an easy and quick tool to create a backup of MySQL databases. It creates a dump file...

  • 1 Users Found This Useful

Was this answer helpful?