mySQL 8 / PHP: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root

README.md

Error beim Verbinden mit der Datenbank: php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

Lösung: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

Grund: neue default-Authentifizierungsmethode bei mySQL >8. Quelle: https://stackoverflow.com/questions/50026939/php-mysqli-connect-authentication-method-unknown-to-the-client-caching-sha2-pa