/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 vote147 views1 answer
How to to get time in sql
SQL
0 vote126 views1 answer
Select last 2 characters sql
SQL
0 vote153 views1 answer
Isnull in sqlite
SQL
2 votes159 views1 answer
Mysql now format
SQL
6 votes150 views1 answer
To count number of rows in SQL table
SQL
0 vote129 views1 answer
How to update sql server version
SQL
5 votes116 views2 answers
Add column postgres with default value
SQL
4 votes173 views1 answer
Postgresql list sequences
SQL
-1 vote130 views1 answer
Concat two columns in sql server
SQL
12 votes124 views2 answers
Delete entries in postgresql
SQL