Description
Describe the bug
I've configured "ALLOW_DDL_OPERATIONS": "true",
"SCHEMA_DDL_PERMISSIONS": "true",
"MULTI_DB_WRITE_MODE": "true"But it still won't execute the ddl op
Platform
roo in cursor
MCP Configuration
{
"mcpServers": {
"mcp_server_mysql": {
"command": "cmd",
"args": [
"/c",
"npx",
"-y",
"@benborla29/mcp-server-mysql"
],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASS": "88888888",
"MYSQL_DB": "",
"MYSQL_POOL_SIZE": "10",
"MYSQL_QUERY_TIMEOUT": "30000",
"MYSQL_CACHE_TTL": "60000",
"MYSQL_RATE_LIMIT": "100",
"MYSQL_MAX_QUERY_COMPLEXITY": "1000",
"MYSQL_SSL": "false",
"ENABLE_LOGGING": "false",
"MYSQL_LOG_LEVEL": "info",
"MYSQL_METRICS_ENABLED": "true",
"ALLOW_INSERT_OPERATION": "true",
"ALLOW_UPDATE_OPERATION": "true",
"ALLOW_DELETE_OPERATION": "false",
"ALLOW_DDL_OPERATIONS": "true",
"SCHEMA_DDL_PERMISSIONS": "true",
"MULTI_DB_WRITE_MODE": "true"
},
"disabled": false,
"alwaysAllow": []
}
}
}
Screenshots
Additional context
Have restarted mcp to try and get the permissions to take effect but no luck!