当前位置：网站首页>Error: ER_ NOT_ SUPPORTED_ AUTH_ MODE: Client does not support authentication protocol requested by serv

Error: ER_ NOT_ SUPPORTED_ AUTH_ MODE: Client does not support authentication protocol requested by serv

2022-04-22 05:04:00 【畱䶒】

1、 Cause of error

Use vscode Connecting the machine mysql When , Reported the mistake .

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2、 The reason for the error

Find information about the night , It's about the current database connection node-mysql The module does not comply with the new rules , So this error will be reported , Then we only need to modify the old module to solve the problem .

3、 Problem solving

3.1 Use the terminal to enter the database

First, use your terminal program to enter the database , And enter the password of your database .

mysql -uroot -p

3.2 Choose to use mysql library

use mysql;

3.3 lookup user In the table user and host Field

select user,host from user;

Please add a picture description

3.4 Modify the specified user

root Is the user name ,localhost It's the host address , hinder 12345678 It's a password

alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘12345678’;

4、 Complete the modification , Successfully connected