How to interface with MySql 9.6?

[Steven Schveighoffer]

On Thursday, 19 February 2026 at 22:54:42 UTC, realhet wrote:
> Hi,
>
> I tried to get help form AI but it's fooling me relentlessly ;)
>
> I've tried mysql-d/mysql-native.
> It says can't connect because the authentication method not 
> supported.
> MySql 9.6 supports only these: sha256_password, 
> caching_sha2_password
> I can't select the old plugin called: mysql_native_password

This was a known issue with 8, I have punted on it for a long 
time because mysql-native uses a pure D implementation, and I'm 
not sure what to do for cryptography in this case.

Issue is here: https://github.com/mysql-d/mysql-native/issues/189

> Now I'm, gonna try mysql-d/mysql-native with an old MySql4 
> server.

I've used Mysql 8 with mysql-native for a while. You just have to 
disable the requirement to use encryption for the password 
exchange.

I have not tried Mysql 9 yet, but it sounds like that option is 
no longer available.

-Steve