[MCP Bug] mysql-mcp-server

[adgower]

it's keep just saying client closed on cursor

config:

"mysql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli@latest",
        "run",
        "mysql-mcp-server",
        "--key",
        "8cb5fa5e-c39c-4ff5-9a9c-71d91b1be131"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "mcp_user2",
        "MYSQL_PASSWORD": "mcp_password",
        "MYSQL_DATABASE": "notify"
      }
    }

[arjunkmrm]

@adgower thanks for your patience. This server runs remotely hence the issue accessing your db. Can you try this local server instead? https://smithery.ai/server/@benborla29/mcp-server-mysql

[adgower]

okay now I understand. I got it working so you don't need config in the env params you just create the mcp using your creds and then use the code with key and it auto loads the creds from the smithery servers?

[arjunkmrm]

That's correct, if you choose 'save and connect', we automatically fetch your credentials when running the server. If you don't have a saved config, and just click 'connect', then your config (including env vars) will be attached to --config flag. Regardless, you wouldn't have to manually set up the env vars.

Feel free to reach out again if there any other issues.