mysql_mcp_server icon indicating copy to clipboard operation
mysql_mcp_server copied to clipboard

Additional config needed when connecting to older MySQL version

Open kirikorneev opened this issue 11 months ago • 3 comments

I am running a MySQL instance with 5.7 version. When trying to connect to it I was getting SSL connection errors (because of TLS stuff, ChatGPT told me) so I had to adjust the config code:

"ssl_disabled": True,
"allow_local_infile": True

Is it possible to add an env var for it, something like MYSQL_DISABLE_SSL?

kirikorneev avatar Mar 20 '25 14:03 kirikorneev

The mysql_mcp_server doesn't include SSL internally, so there is no need for a flag to disable it. When required, users can tunnel SSL with a modular tool like PuTTY.

designcomputer avatar Mar 20 '25 17:03 designcomputer

The mysql_mcp_server doesn't include SSL internally, so there is no need for a flag to disable it. When required, users can tunnel SSL with a modular tool like PuTTY.

Without disabling it, I was getting this error: Error executing query: 2026 (HY000): SSL connection error: error:0A000102:SSL routines::unsupported protocol

kirikorneev avatar Mar 20 '25 20:03 kirikorneev

Maybe you were trying to connect to a port that expected SSL. The mysql_mcp_server doesn't include SSL support of any kind.

designcomputer avatar Mar 20 '25 20:03 designcomputer