Mysql Error-could not open single-table tablespace file

Symptoms

Unable to start MySQL/mysqld service. The following errors are foundin /var/log/mysqld.log:

[ERROR] InnoDB: innodb-page-size mismatch in tablespace ./phpmyadmin_rq_U9tqAuU26/pma_central_columns.ibd (table phpmyadmin_rq_U9tqAuU26/pma_central_columns)...
InnoDB: Error: could not open single-table tablespace file ./phpmyadmin_rq_U9tqAuU26/pma_central_columns.ibd

Cause

Crash recovery of InnoDB cannot be finished because the table is corrupted during the recovery process.

Resolution

• Log in to the server via SSH.

• Move the file mentioned in the error message to the other directory:

  $ mv /var/lib/mysql/phpmyadmin_rq_U9tqAuU26/pma_central_columns.ibd ~/
  

• Start the mysqld service (InnoDB recovery process will be executed automatically):

  $ service mysqld start