PHP & MySQL | Tutorials

David Carr

MySQL 8 The server requested authentication method unknown to the client

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).

Support my work by donating with PayPal.

Subscribe to my newsletter

Subscribe and get my books and product announcements.

© 2009 - 2020 DC Blog. All code MIT license. All rights reserved.