How to interface with MySql 9.6?

[realhet]

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

The other library I tried was: github.com/pszturmaj/ddb
But I only see postgres.d module there. AI just hallucinated 
mysql.d there for me to please me.

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


If anyone knows, how can I use a lightweight sql server on my own 
machine from DLang in 2026, please tell me.