node js - mysql setting

[bccfcc]

shell
npm install
npm install mysql

node mysql connection

var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'userid',
password : 'userpw',
database : 'dbname'
});

connection.connect();

connection.query('query', function(error, results, fields){
if(error) {
console.log(error);
};
console.log(results);
});

connection.end();

Shell
node mysql.js

** Error **
code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',

** Error -Solution **
Changed USERPW
alter user 'userid'@'localhost' identified with mysql_native_password by 'userpw!';