stib<p>Hey <a href="https://aus.social/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysql</span></a> thing-knowers. I've just installed mysql 9.2, and <a href="https://aus.social/tags/php" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>php</span></a> 8 on a <a href="https://aus.social/tags/WindowsServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WindowsServer</span></a>. 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]` <br>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`.<br>I know exactly enough mysql and php to cause headaches for people who know what they're doing, is anyone able to help out?<br><a href="https://aus.social/tags/AskFedi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AskFedi</span></a> <a href="https://aus.social/tags/Webserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Webserver</span></a></p>