mysql不兼容报错,Node.js和MySQL-错误：1251-客户端不支持服务器请求的身份验证协议；考虑升级MySQL客户端...

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

解决方案

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

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