If you are working on a local server like XAMPP/WAMP which runs MariaDB, it would use utf8mb4_unicode_520_ci instead of MySQL's utf8mb4_0900_ai_ci.

To fix the issue:

COLLATE=utf8mb4_0900_ai_ci replace with COLLATE=utf8mb4_general_ci

sed -i 's/COLLATE=utf8mb4_0900_ai_ci/COLLATE=utf8mb4_general_ci/g' yourfile.sql