Laravel/Lumen : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

Asked Aug 06 '21 at 12:24

Active Aug 06 '21 at 12:29

Viewed 217 times

I uploade my Laravel/Lumen api to server after I checked it on localhost. for any query I have using (Where) it gives me same error such as this:

SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from `seasons` where `status` = active limit 1)

for example the above error get from this line as postman mentioned :

$season = Season::where('status','active')->first();

if I have simple return Like :

$router->get('/',function (){
        return "welcome";
    });

it is return successfully ,How can I solve this?

edited Aug 06 '21 at 12:29

Milad

asked Aug 06 '21 at 12:24

Sermed mayi

1

Did you check the credentials of your database in `.env`? – Milad Aug 06 '21 at 12:31
You can check this https://stackoverflow.com/questions/50547724/how-to-resolve-the-error-sql-authentication-method-unknown-in-laravel-mysql – S N Sharma Aug 06 '21 at 12:33
@Milad yes i did and will check it again – Sermed mayi Aug 06 '21 at 12:34
@Milad thanks yes it was .env file mistake , I forgot replace root username – Sermed mayi Aug 06 '21 at 12:36
@Milad you can put answer to accept it – Sermed mayi Aug 06 '21 at 12:37
1

I'm glad you solved it. I don't think it's necessary to add an answer. Keep developing :) – Milad Aug 06 '21 at 12:38

Laravel/Lumen : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

0 Answers0