MySQL 8 The server requested authentication method unknown to the client

David Carr

Tutorials PHP & MySQL

On a new installation of MySQL 8 you may come across the error below when running the 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).

Copyright © 2006 - 2024 DC Blog - All rights reserved.