1 先查错误的字符集存在哪些表里： select TABLE_SCHEMA,TABLE_NAME,TABLE_COLLATION from information_schema.tables where table_collation = 'utf8mb4_0900_ai_ci'  and table_schema = 'jh'; 2 发现无法修改，使用mysql命令行+root权限还是失败 update information_schema.tables  set table_collation = 'utf8_general_ci' where table_collation = 'utf8mb4_0900_ai_ci' and table_schema = 'jh'; 3 傻傻的导出.sql文件，然后批量把 ``` 字符：utf8mb4_0900_ai_ci 替换为：utf8_general_ci  ``` utf8mb4_0900_ai_ci 修改为自己的mysql相对应的 我这里修改为 ``` utf8mb4_general_ci ```