MySQL 8.0 error The server requested authentication method unknown to the client solution

After installing the latest version 8.0.11 of mysql, create a user and authorize it. The authorized user is prompted to connect to the database

The server requested authentication method unknown to the client

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

Solution:

Delete the created users and authorizations.

1. Find the mysql configuration file and add
2. default_authentication_plugin=mysql_native_password

Change to the original authentication method, then create a new user and authorize

or

mysql -uroot -p
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your password';

The above is the solution to this error. If you have a better solution, please leave a message on the 123WORDPRESS.COM WeChat public account. Thank you for your support of 123WORDPRESS.COM.