/SQL/Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true

Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true

[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

Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true

You have to reconfigure MySQL Server. for that follow these steps.

1) Open mysql intsaller.

2) Click on Reconfigure (to the left mysql server)

3) Go to Authentication method tab (by clicking on Next twice.)

4) Then select the radio button Use Legacy Authentication Method. Click Next.

5) Enter your password. Click on Check. Go to Apply Configuration (by clicking on Next twice).

6) Click on Execute. Then Finish.

Source: stackoverflow.com

Errno: 1251

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

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

Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true

mysql_native_password

Similar codes

11 votes278 views2 answers
Set default column value sql
SQL
104 votes474 views2 answers
Like in mysql
SQL
0 vote298 views1 answer
How to insert a uniqueidentifier in sql
SQL
3 votes270 views2 answers
Oracle sql drop sequence
SQL
1 vote317 views1 answer
Mysql select row max date
SQL
0 vote257 views1 answer
Metada in sql
SQL
0 vote322 views2 answers
How to drop mili second in sql
SQL
0 vote257 views2 answers
Avg() sql
SQL
0 vote299 views2 answers
Oracle create tablespace autoextend
SQL
3 votes326 views5 answers
No module named 'MySQLdb'
SQL