DEV Community

Discussion on: MCP Server for MySQL

Collapse
 
madlad_8 profile image
Arpan Bhusal

did this stop working ,i am new to mcp i tried to implement this but it always says connection lost

Collapse
 
benborla profile image
Ben Borla

What’s your configuration looks like and which tool are you using this to?

Collapse
 
madlad_8 profile image
Arpan Bhusal • Edited

config = {
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@benborla29/mcp-server-mysql"
],
"env": {
"DB_HOST": str(DB_HOST),
"DB_PORT": str(DB_PORT),
"DB_USER": str(DB_USER),
"DB_PASSWORD": str(DB_PASSWORD),
"DB_NAME": str(DB_NAME)
}
}
}
}
but instead of configuring in claude desktop , i am trying to have this configured to web-ui (FLASK APP).

Thread Thread
 
madlad_8 profile image
Arpan Bhusal

This works with claude-desktop now, but doesnt work if you have a your own web-ui.

Collapse
 
ronni_celler_6c7a920be628 profile image
Ronni Celler

Same here. Have the issue omn Gemini CLI

Then I tested the MCP server satndalone: The latest Version 2.0.5 silently dies after saying it was version 2.0.2
Starting MySQL MCP server v2.0.2...

When I explicitly install version 2.0.2: npm install -g @benborla29/mcp-server-mysql@2.0.2
it runs with the same configuration (although it says it is v2.0.1 ;-) )

Collapse
 
benborla profile image
Ben Borla

Try the version2.0.5