Solved: Error 1273 Unknown Collation utf8mb4_0900_ai_ci in MySQL

Have you recently encountered the Unknown Collation: utf8mb4_0900_ai_ci in MySQL error? That's because the databases' character sets are incompatible. To find the solution, read this blog post all the way through.



I recently used MySQL to manually import a database to a new server. Everything was going well... till unknown collation: 'utf8mb4 0900 ai ci' displayed on my screen.


I looked deeper to discover the true problem and discovered that the new database's collation was different from the old one. I'll explain the approach I took to resolve this problem in this post. But first, let's clarify what "Collation" in MySQL means.

For the solution to this error, visit: https://meetanshi.com/blog/error-127...i-ci-in-mysql/