Nativeformysql connects to MySQL 8 prompt: 1251 - client does not support authentication protocol

In today's Windows11 The system has MySQL8 database , Use NativeForMySQL Connect MySQL8 The database prompts the following error message ：

1251- Client does not support authentication protocol

The Internet says the reason for this is ：mysql8 In previous versions, the encryption rule was mysql_native_password, And in the mysql8 after , The encryption rule is caching_sha2_password,

terms of settlement ：

Method 1. upgrade navicat drive ;

Method 2. hold mysql The user login password is restored to mysql_native_password.

The following demo uses Method 2 solve , The specific operation steps are as follows ：

1. Open the command line small black screen , Get into MySQL Of bin Catalog , Then input mysql -u root -p, Input password

2. Input again

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; # Update the user's password ,password Custom password for  

FLUSH PRIVILEGES; # Refresh the permissions 

3. Enter the password you just changed , Test the connection again , Can connect successfully