node连接Mysql报错ER_NOT_SUPPORTED_AUTH_MODE

var mysql  = require(‘mysql‘);  
 
var connection = mysql.createConnection({     
  host     : ‘localhost‘,     //本机地址
  user     : ‘root‘,          //用户
  password : ‘123456‘,        //密码
  port: ‘3306‘,               //端口号
  database: ‘test‘            //要连接的数据库
}); 
 
connection.connect();
 
var  sql = ‘SELECT * FROM table1‘;   //查询table1表的所有数据

connection.query(sql,function (err, result) {
        if(err){
          console.log(‘[SELECT ERROR] - ‘,err.message);
          return;
        }
 
       console.log(‘--------------------------SELECT----------------------------‘);
       console.log(result);
       console.log(‘------------------------------------------------------------\n\n‘);  
});
 
connection.end();

F:\All Project\test\node>node test.js
[SELECT ERROR] -  ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

mysql> alter user ‘root‘@‘localhost‘ identified with mysql_native_password by ‘123456‘;
Query OK, 0 rows affected (0.27 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.08 sec)

F:\All Project\test\node>node test.js
--------------------------SELECT----------------------------
[ RowDataPacket {
    id: ‘1‘,
    name: ‘Google‘,
    url: ‘https://www.google.com‘,
    alexa: ‘1‘,
    country: ‘USA‘ },
  RowDataPacket {
    id: ‘3‘,
    name: ‘Facebook‘,
    url: ‘https://www.facebook.com‘,
    alexa: ‘3‘,
    country: ‘USA‘ },
  RowDataPacket {
    id: ‘4‘,
    name: ‘微博‘,
    url: ‘https://www.weibo.com‘,
    alexa: ‘4‘,
    country: ‘CN‘ } ]
------------------------------------------------------------