Unknown collation: 'utf8mb4_is_0900_ai_ci'

回答: 出现错误"Unknown collation: 'utf8mb4_is_0900_ai_ci'"是因为在将高版本的MySQL（比如MySQL 8.0）的SQL文件导入到低版本的MySQL（比如MySQL 5.6）时，出现了版本不兼容的情况。解决这个问题的方法是将SQL文件中所有的"utf8mb4_0900_ai_ci"替换为"utf8_general_ci"，并将"utf8mb4"替换为"utf8"。这样做可以解决该错误。 [1][2][3<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [mysql报错Unknown collation: utf8mb4_0900_ai_ci](https://blog.csdn.net/mtyedu/article/details/124776084)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [Unknown collation: ‘utf8mb4_0900_ai_ci‘的解决方法](https://blog.csdn.net/weixin_42914989/article/details/113155204)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [【MySQL异常解决】MySQL执行SQL文件出现【Unknown collation ‘utf8mb4_0900_ai_ci‘】的解决方案](https://blog.csdn.net/weixin_44299027/article/details/131725454)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]