Node.js无法对MySQL 8.0进行身份验证

创建连接的代码

const mysql = require('mysql');

const dbConn = mysql.createConnection({
    host: 'localhost',
    port: 3306,
    user: 'root',
    password: '123456',
    database: 'test'
});

dbConn.connect(err => {
    if (err) throw err;
    console.log('Connected!');
});

MySQL 8.0 root帐户使用新密码哈希方法：

> select User,Host,plugin from user where User="root";
+------+-----------+-----------------------+
| User | Host      | plugin                |
+------+-----------+-----------------------+
| root | localhost | caching_sha2_password |
+------+-----------+-----------------------+

解决方案：
解决方法是更改用户帐户的类型以使用旧的身份验证插件：

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

或者是创建一下：

CREATE USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';