Node.js & MySQL - Error: 1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Question

Right now I have only this code:

const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'root', 'passwd', {
  host: 'localhost',
  dialect: 'mysql',

    // http://docs.sequelizejs.com/manual/tutorial/querying.html#operators
  operatorsAliases: false
});
sequelize
  .authenticate()
  .then(() => {
    console.log('Connection has been established successfully.');
  })
  .catch(err => {
    console.error('Unable to connect to the database:', err);
  });

But when I try to run the .js I get this error. I have already tried a lot of solutions out there, including the one I found more often but it didn't work. So right now I don't know what to do. Can somebody help me?

Thank you

What auth modes do you have configured for your server?

Akshara
– Akshara

2018-04-24 06:55:54 +00:00
Commented Apr 24, 2018 at 6:55 — Akshara
– Akshara, Commented Apr 24, 2018 at 6:55
caching_sha2_password

ifhy
– ifhy

2018-04-24 11:40:09 +00:00
Commented Apr 24, 2018 at 11:40 — ifhy
– ifhy, Commented Apr 24, 2018 at 11:40

adiga · Accepted Answer · 2019-06-20 06:43:23Z

33

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

Worked for me. root password is changed to 'password'

edited Jun 20, 2019 at 6:43

adiga

35.4k9 gold badges65 silver badges88 bronze badges

answered Apr 26, 2018 at 5:52

Shimrit Snapir

4633 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Vijay Pant Over a year ago

This worked for me too. I think this is due to the use of SHA256 for password storage in new version of mysql.

etudor Over a year ago

I was working on Docker containers and I needed to change in the query localhost to % because I was connecting to a different hostname. It works!

Akhil S Over a year ago

thanks for your answer, it worked for me and it saves lot of time. thank you.

Akshara · Accepted Answer · 2018-04-24 11:41:29Z

3

Changing the plugin to mysql_native_password might solve the problem!

use mysql;
update user set authentication_string=password(''), plugin='mysql_native_password' where user='root';

answered Apr 24, 2018 at 11:41

Akshara

2111 silver badge9 bronze badges

2 Comments

ifhy Over a year ago

It was in fact about changing the plugin to mysql_native_password but not in that way because as I said on my previous post I tried that but the syntax was wrong. I searched on MySQL documentation and I found this: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; And this worked! Thanks for the help though :)

ganjim Over a year ago

just to clarify, the syntax might be a little different, in my case, it was ... set authentication_string='password', ...

adiga · Accepted Answer · 2019-06-20 06:43:10Z

1

Basically when I was trying to connect to Mysql Query Browser at that time I as facing the issue.

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

Worked for me. root password is changed to 'root'

edited Jun 20, 2019 at 6:43

adiga

35.4k9 gold badges65 silver badges88 bronze badges

answered Oct 13, 2018 at 16:57

Kuldeep Kumar

7541 gold badge7 silver badges12 bronze badges

Comments

mastisa · Accepted Answer · 2019-06-20 06:57:41Z

1

I found out that I was caused by incorrect parameters.

{ database: 'abc',
  username: undefined,
  password: 'efsefs',
}

username is undefined, but the error is "consider upgrading MySQL client" So modify the user name to be true, the error resolved.

edited Jun 20, 2019 at 6:57

mastisa

2,1413 gold badges25 silver badges42 bronze badges

answered Jun 20, 2019 at 5:37

Guoyong Yi

111 bronze badge

1 Comment

Rohan Hussain Over a year ago

Thank you. This was the issue. The environment variable was named USER and wasn't being loaded into the process.env object. I changed its name to MYSQL_USER and it became available and the connection worked.

Collectives™ on Stack Overflow

Node.js & MySQL - Error: 1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

4 Answers 4

3 Comments

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related