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
