MySQL appears 1005

Environment: NavicatforMysql8.2 + MySQL Sever 5.1

Problem: A 105 error occurred creating the foreign key, as shown in the following figure:

WORKAROUND: Delete the reference table and recreate it.

StackOverflow on the face of 105 wrong explanations:

If You re-create a table this is dropped, it must have a definitionthat conforms to the foreign key constraints ng it. It must have theright column names and types, and it must have on the indexes referenced. Keys,as stated. If These are is not satisfied, the MySQL returns error number 1005and refers to error the "error message".

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/MySQL/