This article is in English.

MySQL Error: Importing database: Unknown collation: 'utf8mb4_0900_ai_ci'

This is Github / issues of MySQL.

...(Something else not important to solve this issue)...

Opened the .sql file in Notepad++ ( Alternative: Open the .sql file in Microsoft Word ) and hit CTRL+H ( Alternative: [Microsoft Word] hit CTRL + F ) to find and replace the string “utf8mb4_0900_ai_ci” and replaced it with “utf8mb4_general_ci“.

It worked for me ,hope it will work for u as well.

...(Something else not important to solve this issue)...

Source From:

The above content has been modified, e.Ki does not claim any copyright on this article.

本文作者: 文章标题:Unknown collation: 'utf8mb4_0900_ai_ci' - MySQL Error
Last modification:February 12th, 2021 at 10:47 pm