当前位置：网站首页>Nativeformysql connects to MySQL 8 prompt: 1251 - client does not support authentication protocol

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

2022-04-23 11:56:00 【On the road of struggle】

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  

 

 

版权声明
本文为[On the road of struggle]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204231152214205.html

边栏推荐

猜你喜欢

随机推荐