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