Nov 8, 2018

How to fix: Adding MySQL foreign key: Error 1005

If you encounter
 Error 1005: Can't create table 'i88ca.#sql-185a_c273d' (errno: 150) SQL Statement: ALTER TABLE ...... CHARSET=utf8 
 One of the solution is to check and make sure that the storage engine of the table referred to by the foreign key is innodb, not MyISAM.