Tutorials, PHP & MySQL

On a new installation of MySQL 8 you may come across the error below when running application.

The server requested authentication method unknown to the client

The simple fix is to go login to the MySQL shell:

mysql -uroot

then run:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';

This updates the root user to be identified with no password (or the one you've specified).