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

Question

Could someone tell what error "ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client" means?

My code:

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "user",
  password: "password",
  database: 'database'
});

con.connect(function(err) {
  if (err) throw 'THE ERROR IS: ' + err;
  console.log("Connected!");
});

do you tried that solution? https://stackoverflow.com/questions/44946270/er-not-supported-auth-mode-mysql-server — Abraao Duarte, Jan 29 '21 at 15:09

score 0 · Answer 1 · answered Jan 29 '21 at 17:35

0

In the link that I sent for you, was added this property: insecureAuth : true.

var con = mysql.createConnection({
  host: "localhost",
  user: "user",
  password: "password",
  database: 'database',
  insecureAuth : true

});

answered Jan 29 '21 at 17:35

Abraao Duarte

23
3

Try this: `sudo mysql -u root -p` `ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ChoosePassword';` `FLUSH PRIVILEGES;` – Abraao Duarte Jan 29 '21 at 20:35

score 0 · Answer 2 · edited Nov 19 '21 at 14:59

0

I also faced the same issue but the error got resolved by using mysql2 instead of mysql. so type

npm install mysql2

in your terminal. and update your code with

const mysql = require("mysql2");

edited Nov 19 '21 at 14:59

Suraj Rao

29,388
11
94
103

answered Nov 19 '21 at 14:58

Ahsan Nawaz

1

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

2 Answers2