MySQL Error MY-012127 – ER_IB_MSG_UNEXPECTED_FILE_EXISTS

MySQL Error Message

The file ‘%s’ already exists though the corresponding
table did not exist. Have you moved InnoDB .ibd files around
without using the SQL commands DISCARD TABLESPACE and IMPORT
TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You
can resolve the problem by removing the file ‘%s’ under the
‘datadir’ of MySQL.

Reason for the Error

ER_IB_MSG_UNEXPECTED_FILE_EXISTS
was added in 8.0.17.