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

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

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 vs code

A possible workaround is to alter the type of user account to use the old authentication plugin:

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

Or create a different one that uses that same plugin:

CREATE USER 'foo'@'localhost' IDENTIFIED WITH mysql_native_password BY 'bar';

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 vote342 views1 answer
Populate db from command line postgres
SQL
8 votes495 views4 answers
Convert date to dd/mm/yyyy sql
SQL
1 vote326 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote367 views4 answers
Get week day from date in sql
SQL
2 votes295 views1 answer
Oracle sql drop column if exists
SQL
1 vote833 views1 answer
Athena query timestamp greater than
SQL
1 vote339 views1 answer
Multiple count in sql
SQL
0 vote348 views1 answer
Frename oracle
SQL
-1 vote366 views5 answers
Convert sql to linq query online
SQL
0 vote352 views1 answer
Update having mysql
SQL