/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 vote227 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote219 views1 answer
Excel export from sql using python
SQL
0 vote213 views1 answer
Mysql enter ubuntu
SQL
1 vote347 views3 answers
Sql subquery
SQL
0 vote208 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote205 views1 answer
Print intervals of 15 minutes in sql query
SQL
10 votes164 views2 answers
Django mysql
SQL
-1 vote219 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote214 views1 answer
Exec procedure oracle
SQL
8 votes236 views1 answer
Oracle add auto_increment column to existing table
SQL