How to solve the problem of mysql 8.0 error The server requested authentication method unknown to the client

This article is about how to solve the problem of mysql 8.0 error The server requested authentication method unknown to the client. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

After mysql has installed the latest version 8.0.11, the authorized user is prompted to connect to the database after the user is created and authorized.

The server requested authentication method unknown to the client

After consulting some relevant information, it is found that it is caused by the inconsistency of the password unlocking mechanism of the new version of mysql account.

Solution:

Delete created users and authorizations

Locate the mysql configuration file and join

Default_authentication_plugin=mysql_native_password

Change to the original authentication method, and then re-create the user and authorize it.

Or

Mysql-uroot-puse mysql;ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY'; thank you for reading! This is the end of this article on "how to solve the problem of mysql 8.0 error The server requested authentication method unknown to the client". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!