mysql_mcp_server - ERROR - Failed to list resources: 1105 (HY000): invalid collation utf8mb4_0900_ai_ci

[nvidi]

使用时遇到如下问题：mysql_mcp_server - ERROR - Failed to list resources: 1105 (HY000): invalid collation utf8mb4_0900_ai_ci
我的环境是：mysql8.0.27
ide环境：vscode+cline
"mydb": {
"disabled": false,
"timeout": 30,
"command": "uv",
"args": [
"--directory",
"/Library/Frameworks/Python.framework/Versions/3.13/bin",
"run",
"mysql_mcp_server"
],
"env": {
"MYSQL_HOST": "xxx",
"MYSQL_PORT": "3306",
"MYSQL_USER": "xxx",
"MYSQL_PASSWORD": "xxx",
"MYSQL_DATABASE": "xxx",
"MYSQL_CHARSET": "utf8mb4",
"MYSQL_COLLATION": "utf8mb4_general_ci",
"MYSQL_SQL_MODE": "TRADITIONAL"
},
"transportType": "stdio"
}
我在另一个服务器上另外安装的一个mysql5.7是可以连接成功的，但是在上述的环境和数据库的情况下就一直报错。

[nvidi]

我的mysql执行下面的语句时执行得到的结果是：
SHOW VARIABLES LIKE 'character_set_%';
SHOW VARIABLES LIKE 'collation_%';

character_set_client utf8mb3
character_set_connection utf8mb3
character_set_database utf8mb3
character_set_filesystem binary
character_set_results utf8mb3
character_set_server utf8mb4
character_set_system utf8mb3
character_sets_dir /opt/tiger/app/ndb-1.0.0/share/charsets/

collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server utf8mb4_0900_ai_ci

然后我在配置里尝试了如下组合，都依然报同样的错误：
"MYSQL_CHARSET": "utf8mb4",
"MYSQL_COLLATION": "utf8mb4_general_ci",

"MYSQL_CHARSET": "utf8mb3",
"MYSQL_COLLATION": "utf8_general_ci",

"MYSQL_CHARSET": "utf8mb3",
"MYSQL_COLLATION": "utf8mb4_general_ci",

[designcomputer]

These attributes are optional and only for use with MySQL 5.7 and earlier. They are also only available in the development version, not the release version. So I'll remove them from the documentation until I've done further testing.

MYSQL_CHARSET=utf8mb4
MYSQL_COLLATION=utf8mb4_unicode_ci