Bradley Grainger

Use `Environment.UserName` as the default user name

1

This SO user (https://stackoverflow.com/questions/71742985/how-to-compose-a-connection-string-without-login-credentials-net-mysqlconnector) expects `MySqlConnectionStringBuilder.UserID` to default to the current Unix user when connecting via a Unix socket. That is how some other MySQL client libraries behave: https://dev.mysql.com/doc/refman/8.0/en/user-names.html >...

Support new server connection string option format

4

[Connector/NET 8.0.19 introduces](https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-19.html) a new format for the `Server` connection string option: ``` // Example with priority server=(address=192.10.1.52:3305,priority=60),(address=localhost:3306,priority=100); // Example without priority and with multiple ports host=10.10.10.10:3306,192.101.10.2:3305,localhost:3306;uid=test;password=xxxx; ``` Specifying multiple...

Starting in 8.0.10, Connector/NET allows `AllowPublicKeyRetrieval` to be set in the connection string: https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html Need to update https://github.com/mysql-net/MySqlConnector/blob/e5cc8114730eaaa2c45921db688da3e17152c8ae/docs/content/tutorials/migrating-from-connector-net.md?plain=1#L51

Create MySqlConnector.OpenTelemetry package

1

This could be a very simple shim that adds a `public static TracerProviderBuilder AddMySqlConnector(this TracerProviderBuilder builder)` API. See Npgsql implementation https://github.com/npgsql/npgsql/tree/main/src/Npgsql.OpenTelemetry and documentation https://www.npgsql.org/doc/diagnostics.html#tracing-with-opentelemetry-experimental for an example.

Improve MySqlBulkCopy API

8

The API for `MySqlBulkCopy` was patterned on `SqlBulkCopy`, which has no return value from its `WriteToServer` method. https://github.com/mysql-net/MySqlConnector/issues/1005 points out that warnings are not surfaced to the user. `MySqlBulkCopy.WriteToServer` will...

System.Threading.Tasks.Extensions 4.5.4 has been available for two years now, and still supports .NET 4.5; update to it (probably in a v2.2.0 release).

Switch to Microsoft.Extensions.Logging

1

MySqlConnector currently implements logging via a custom interface: https://github.com/mysql-net/MySqlConnector/issues/390 Npgsql is planning to replace their custom logging interface with Microsoft.Extensions.Logging (https://github.com/npgsql/npgsql/issues/2103#issuecomment-997813520): > Looking at this again, we should really consider...

Improve `InvalidCastException` message for `MySqlDataReader.GetX()`

6

From https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/1571#issuecomment-1017955409 If `MySqlDataReader.GetX()` is called for the wrong data type, or when the underlying data is `NULL`, it will throw `InvalidCastException: Unable to cast object of type 'System.DBNull' to...

Support multifactor authentication

2

New in MySQL Server 8.0.27: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-27.html#mysqld-8-0-27-authentication https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html

Support zstd compression

4

MySQL 8.0.18 introduces the option to use `zstd` compression: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-18.html#mysqld-8-0-18-connection-control > MySQL now provides more control over the use of compression to minimize the number of bytes sent over connections...