The problem is the version of MySQL. This collation was added with MySQL 8.0 and is the new default. MySQL 5.7.32 does not have it. Since the create table statement includes it, clearly it is designed for MySQL 8.0 or above.
A big related question is whether there are any **functional** requirements in Codidact that need MySQL above 5.7.32. If there are, then the only practical solution is to install MySQL 8.0 or above in your system, or connect to a MySQL server elsewhere that is running 8.0 or above.
If there are no issues other than the collation, you can change all references to utf8_general_ci or another common collation. See https://stackoverflow.com/questions/57546833/how-to-take-a-dump-from-mysql-8-0-into-5-7 for a similar question.
manassehkatz
·
2021-01-24T03:59:03Z (almost 4 years ago)