Hey #mysql thing-knowers. I've just installed mysql 9.2, and #php 8 on a #WindowsServer. When I try to use mysqli_connect in my php application I get the error `mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password]`
On the mysql side the user is identified with caching_sha2_password. All the answers to this problem I've found seem to be quite old, and they all recommend altering the user to `mysql_native_password`. This seems like a retrograde step, but I gave it a go, and when I tried to do that I got `Error 1524 HY0000: Plugin mysql_native_password is not loaded`.
I know exactly enough mysql and php to cause headaches for people who know what they're doing, is anyone able to help out?
#AskFedi #Webserver