MySQL SSL connection error: protocol version mismatch

Hello,

when connecting to MySQL, we get the error message “SSL connection error: protocol version mismatch”.

Someone has an idea how to check SSL Version for MySQL plugin?

Trying to get in with Christoph. MySQL workbench works with same settings.
Just MySQLCommunityServer does not.

SSLMode = false on a Mac gets you in, but not secure.

SSLMode = false on Windows fails here with protocol version message from above.
Any idea?

MBS SQL Plugin works´with and without SSL, so we may use that one.

And reported: <https://xojo.com/issue/50430>

We have the same issue here.

Welcome as a new user of MBS SQL Plugin :slight_smile:

“New” since 2014 :wink:

BTW @Christian, is there a “simple” example or explanation on how to move a Xojo mySQLCommunity Server Connection to MBS SQL, so that only the connection is replaced with MBS but the rest of the methods for accessing the mySQL Server with Prep.Statements stays the same? Or do we have to replace all the Xojo mySQL Code?

Until now, i just used your Plugin to access a MS MSQL Server.

change mySQLCommunityServer class uses with SQLDatabaseMBS class.

Than change connecting code and use of mySQLPreparedStatements.
That should be most of it.

We are seeing the “SSL connection error: protocol version mismatch” Message more and more across all our mySQL connections, without having touched our mySQL Code or our mySQL Servers/Connections for many weeks. No updates have been done, afaik.

<https://xojo.com/issue/50430>: Is anybody else experiencing this and is there already a known pure Xojo based solution available?

[quote=360834:@Christian Schmitz]change mySQLCommunityServer class uses with SQLDatabaseMBS class.

Than change connecting code and use of mySQLPreparedStatements.
That should be most of it.[/quote]

BTW: Thank you Christian. It works just fine now with MBS.

PS: Still would like to see Xojo solving the Issue with their Plugin :wink: