[Question] Mysql 8 auth support for mysql2 server

[haganbt]

Is caching_sha2_password supported when using mysql2 as a server/proxy?

I cannot see any references in the examples.

Appreciate any guidance.

[sidorares]

sorry for delays @haganbt I'll get back with more detailed answer soon

caching_sha2_password is not supported out of the box yet. It's still possible to have it I believe but you'd need to handle all auth packets sequence manually in the server code ( which is a bit more complicated than one roundtrip salt -> auth(password, salt)` mysql_native_password flow )

[haganbt]

Any further clarification here @sidorares would be very much appreciated.

[pureLifeWater101]

Any updates on this? Is this supported out of the box now? @sidorares

[sidorares]

Still not possible but I plan to look at that soon. Probably needs "server api at command (state machine managing sequence of packets ) level, not just individual packets" - some initial work started 2 years ago in #1405