MySQL 9.2 is expected to introduce new changes, deprecations, and improvements. To ensure Vitess remains compatible with the latest MySQL versions, we need to add support for MySQL 9.2.

There's no current MySQL 9.x LTS release yet, so this hasn't been much of a priority. The major will be that we have to handle the removal of mysql_native_password which we hard depend on right now for how we set up replication in MySQL from Vitess.

This has to be switched to caching_sha2_password, but that requires TLS certificate setup within the Vitess cluster. Either also replication needs to be TLS, or plain text is still used but then you still need the certificates for the caching_sha2_password handshake to authenticate.