How to resolve: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client?

Question

I get the error whenever I try to access the route created with valet home.test. I have tried all the solutions listed in similar issues like this solution but nothing seems to work

The error is:

SQLSTATE[HY000] [2054] The server requested authentication method 
unknown to the client (SQL: select * from `user_meta` where `user_id` is null limit 1)

MySQL version - 8.0.19
PHP version - 7.4.7

My migrations work fine as I can see the tables created.

Any help would be appreciated.

Update.env config

DB_CONNECTION=mysql

DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=home
DB_USERNAME=root
DB_PASSWORD=abcd

TENANCY_HOST=localhost
TENANCY_PORT=3306
TENANCY_DATABASE=home
TENANCY_USERNAME=root
TENANCY_PASSWORD=abcd

This may help you [Link 1](https://stackoverflow.com/a/53881212/6189461) — Rafik Farhad, Jul 13 '20 at 12:28
This was happening to me when using laravel but running commands such as `migrate` from the wrong shell. See my answer here: https://stackoverflow.com/a/66910286/241138 — Andrew, Apr 01 '21 at 19:29

score 1 · Answer 1 · answered Jul 13 '20 at 11:35

1

I guess this query solved your problem.

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

answered Jul 13 '20 at 11:35

Senthurkumaran

1,482
2
16
25

How to resolve: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client?

1 Answers1