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 was happening to me when using laravel but running commands such as migrate from the wrong shell. See my answer here: stackoverflow.com/a/66910286/241138 — Andrew
– Andrew, Commented Apr 1, 2021 at 19:29

Senthurkumaran · Accepted Answer · 2020-07-13 11:35:09Z

5

I guess this query solved your problem.

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

answered Jul 13, 2020 at 11:35

Senthurkumaran

1,8882 gold badges22 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammed Abir · Accepted Answer · 2022-10-05 12:19:40Z

You have to change MySQL settings. Edit /etc/mysql/mysql.conf.d/mysqld.cnf file and put this setting in mysqld section:

[mysqld] default_authentication_plugin= mysql_native_password

Then run following command:

FLUSH PRIVILEGES;

Then you may need to restart the mysql services for the changes to take effect:

sudo service mysql restart

I tried every solution possible, but this was the only one that worked.

Igor · Accepted Answer · 2025-01-16 02:50:03Z

The main reason is that here is a new MySQL version, but an old PHP version. Since MySQL 8.0.34 (i think your version is not 8.0.19 and it's higher) using a new authentication method and old auth method mysql_native_password is deprecated. I faced with this issue in a Moodle.

💡 Solution for error authentication method unknown to the client is to update PHP version to 8+ or downgrade MySQL version to 5.7.

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Linked

Related