/SQL/[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[2021-10-05T13:43:48.961Z] error Error: 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

Similar codes

16 votes236 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote242 views1 answer
Sqlalchemy orm duplicate
SQL
1 vote280 views1 answer
Delete dublicate rows sql
SQL
0 vote224 views2 answers
Sql drop view if exists
SQL
0 vote228 views1 answer
Sql count matching group by
SQL
12 votes241 views5 answers
Rename table in mysql
SQL
0 vote231 views1 answer
Sql server concat null
SQL
0 vote235 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote184 views1 answer
Oracle function select into
SQL
4 votes208 views1 answer
Postgresql show current database
SQL