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

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

Execute the following query in MYSQL Workbench

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Where root as your user localhost as your URL and password as your password

Then run this query to refresh privileges:

flush privileges;

Try connecting using node after you do so.

If that doesn't work, try it without @'localhost' part.

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

npm install mysql2

Source: stackoverflow.com

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

const mysql = require("mysql2")

Source: stackoverflow.com

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

import mysql from "mysql2";

Source: stackoverflow.com

Similar codes

0 vote241 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote224 views1 answer
Mysqldump: error:
SQL
0 vote196 views1 answer
ORA-13717
SQL
16 votes218 views2 answers
Sql vs nosql
SQL
0 vote195 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
7 votes204 views1 answer
Grant schema permissions postgres
SQL
36 votes206 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote201 views1 answer
Group by join columns per table
SQL
2 votes245 views3 answers
Sql server reseed identity column
SQL
2 votes207 views3 answers
Copy data from one table column to another table column in sql
SQL