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

Fathom Analytics $10 discount on your first invoice using this link

David Carr - Laravel Developer

Hi, I’m David Carr

A Senior Developer at Vivedia
I love to use the TALL stack (Tailwind CSS, Alpine.js, Laravel, and Laravel Livewire)

I enjoy writing tutorials and working on Open Source packages.

I also write books. I'm writing a new book Laravel Testing Cookbook, This book focuses on testing coving both PestPHP and PHPUnit.

Sponsor me on GitHub

Subscribe to my newsletter

Subscribe and get my books and product announcements.

Laravel Testing Cookbook

Help support the blog so that I can continue creating new content!

Fathom Analytics $10 discount on your first invoice using this link

Subscribe to my newsletter

Subscribe and get my books and product announcements.

© 2006 - 2023 DC Blog. All code MIT license. All rights reserved.