Unknown collation: 'utf8mb4_0900_ai_ci'

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