designcomputer
mysql_mcp_server - ERROR - Failed to list resources: 1105 (HY000): invalid collation utf8mb4_0900_ai_ci
使用时遇到如下问题：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是可以连接成功的，但是在上述的环境和数据库的情况下就一直报错。
我的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",
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
