Re: How to interface with MySql 9.6?

[apz28 via Digitalmars-d-learn]

On Friday, 20 February 2026 at 12:42:13 UTC, apz28 wrote:
On Friday, 20 February 2026 at 00:22:15 UTC, realhet wrote:
[...]

It is a lack of clarification, it supports 4 types
mysql_native_password, SCRAM-SHA-1, caching_sha2_password & 
authentication_windows_client
You need to set 
connection.connectionStringBuilder.integratedSecurity = 
DbIntegratedSecurityConnection.legacy; // To a one that 
required by database server

DbIntegratedSecurityConnection.legacy = mysql_native_password
DbIntegratedSecurityConnection.srp1 = SCRAM-SHA-1
DbIntegratedSecurityConnection.srp256 = caching_sha2_password
DbIntegratedSecurityConnection.sspi = 
authentication_windows_client

    When make build, you need to include all db_myauth_...d 
modules/files so that it will register the authentication method.
        shared static this() nothrow @safe
        {
            DbAuth.registerAuthMap(DbAuthMap(myAuthNativeName, 
DbScheme.my, &createAuthNative));
        }