caching_sha2_password requires an extra roundtrip at login

[bgrainger]

Software versions
MySqlConnector version: 2.4.0
Server type (MySQL, MariaDB, Aurora, etc.) and version: MySQL 9.2.0
.NET version: 8.0

Describe the bug
When the server advertises its authentication method as caching_sha2_password, MySqlConnector attempts to log in with mysql_native_password, which requires an extra round trip to switch authentication.

Expected behavior
Log in immediately with fewer network packets.

Additional context
mysql_native_password is hardcoded here:

MySqlConnector/src/MySqlConnector/Protocol/Payloads/HandshakeResponse41Payload.cs

Line 71 in 20a73ed

writer.Write("mysql_native_password\0"u8);