How to interface with MySql 9.6?

[apz28]

On Friday, 20 February 2026 at 00:22:15 UTC, realhet wrote:
> On Thursday, 19 February 2026 at 23:32:05 UTC, apz28 wrote:
>> On Thursday, 19 February 2026 at 22:54:42 UTC, realhet wrote:
>>> Hi,
>> You can try my packages - if bug found, please create one
>> Look unittest in module pham.db.db_mydatabase for 
>> DbIntegratedSecurityConnection.srp256
>>
>> https://github.com/apz28/dlang/tree/main/source/pham/db
>> https://code.dlang.org/packages/pham_library
>
> Thanks!
>
> pham.db.db_myexception.MyException at c:\d\libs\pham\db\db_myprotocol.d(912): Unsupported authenticated type: mysql_native_password
>
> Now it turned out, that my older MySql version which works with 
> mysql-d/mysql-native is too old for your library.
>
> I've made a user with sha authentication, but the default on 
> this MySql version is still `mysql_native_password`, so the 
> pham.db library gives up.
>
> Now I will stick to MySql5.7, I'm happy that it finally works.  
> And later if I have to work with a bigger server, I will have 
> some ideas.
> Thank you All!

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