Re: MySQL 8.0: Connector/NET - SecureString

[Paul Haynes]

Hello

Thank you for the reply. The SqlConnection has a SqlCredential object which is constructed with a plaintext username and a SecureString password. You then set the SqlConnection.Credential property to go aolongside the rest of the connection string info that was set initially.

This means that the password is not stored in plaintext so cannot be retrieved from memory.

An example of this is here:
https://learn.microsoft.com/en-us/dotnet/api/microsoft.data.sqlclient.sqlcredential?view=sqlclient-dotnet-standard-5.2

It would be excellent if MySQLConnection had an equivalent method for handling passwords that used the SecureString class rather than it being plaintext.