MySQL Error MY-010884 – ER_INNODB_PK_ONLY_IN_MYSQL

MySQL Error Message

Table %s has no primary key in InnoDB data dictionary,
but has one in MySQL! If you created the table with a MySQL
version < 3.23.54 and did not define a primary key, but defined
a unique key with all non-NULL columns, then MySQL internally
treats that key as the primary key. You can fix this error by dump
+ DROP + CREATE + reimport of the table.

Reason for the Error

ER_INNODB_PK_ONLY_IN_MYSQL was
added in 8.0.2.