Fix the MySQL version detection and only use up to MySQL 8.x

planetscale / cli

The CLI for PlanetScale Database

https://planetscale.com/cli

Apache License 2.0

604 stars 51 forks source link

Fix the MySQL version detection and only use up to MySQL 8.x #918

Closed dbussink closed 1 month ago

dbussink commented 1 month ago

MySQL 9.x is backwards compatibility breaking as it removes support for mysql_native_password which is what is used with PlanetScale as the default at the moment.

So enforce MySQL 8.x as the latest at the moment.

Also upgrade planetscale-go and add some empty test mocks for now so it can compile. This update removes a bunch of legacy code so it can't be used accidentally either.

dbussink commented 1 month ago

Fixes #916

dbussink commented 1 month ago

I had https://github.com/planetscale/psdbproxy/pull/24 as an alternative idea here that's more future proof but breaks some really old clients with the CLI / proxy.

dbussink commented 1 month ago

Closing in favor of #919