1286 - Unknown storage engine 'InnoDB'

Symptoms

When accessing a table in phpMyAdmin, you receive the following error.

1286 - Unknown storage engine 'InnoDB'

You will also see entries similar to the following in the MySQL/MariaDB error log.

2022-03-12 15:43:40 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'InnoDB'". Some plugins may be not loaded
2022-03-12 15:43:40 0 [ERROR] Can't open and lock privilege tables: Unknown storage engine 'InnoDB'

Description

The issue commonly occurs when the InnoDB logfiles have become corrupt. Moving the files out of the data directory will force the files to be rebuilt.

Workaround

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Create a storage directory for the files.

   mkdir /root/innodb.bak

3. Stop the SQL service.

   /usr/local/cpanel/scripts/restartsrv_mysql --stop

4. Move the log files to the storage directory.

   mv -v /var/lib/mysql/ib_logfile* /root/innodb.bak/

5. Start the SQL service.

   /usr/local/cpanel/scripts/restartsrv_mysql --start