Node.js无法通过MySQL 8.0进行身份验证?mysql

我有一个Node.js程序，该程序使用root帐户连接到本地MySQL数据库（这不是生产设置）。这是创建连接的代码：

const mysql = require('mysql');

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

dbConn.connect(err => { if (err) throw err; console.log('Connected!'); }); 它可以与MySQL 5.7一起使用，但是由于安装了MySQL 8.0，因此在启动Node.js应用程序时出现此错误：

node .\api-server\main.js [2018-05-16T13:53:53.153Z] Server launched on port 3000! C:\Users\me\project\node_server\node_modules\mysql\lib\protocol\Parser.js:80 throw err; // Rethrow non-MySQL errors ^

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client at Handshake.Sequence._packetToError (C:\Users\me\project\node_server\node_modules\mysql\lib\protocol\sequences\Sequence.js:52:14) at Handshake.ErrorPacket (C:\Users\me\project\node_server\node_modules\mysql\lib\protocol\sequences\Handshake.js:130:18) at Protocol._parsePacket (C:\Users\me\project\node_server\node_modules\mysql\lib\protocol\Protocol.js:279:23) at Parser.write (C:\Users\me\project\node_server\node_modules\mysql\lib\protocol\Parser.js:76:12) at Protocol.write (C:\Users\me\project\node_server\node_modules\mysql\lib\protocol\Protocol.js:39:16) at Socket. (C:\Users\me\project\node_server\node_modules\mysql\lib\Connection.js:103:28) at emitOne (events.js:116:13) at Socket.emit (events.js:211:7) at addChunk (_stream_readable.js:263:12) at readableAddChunk (_stream_readable.js:250:11) -------------------- at Protocol._enqueue (C:\Users\me\project\node_server\node_modules\mysql\lib\protocol\Protocol.js:145:48) at Protocol.handshake (C:\Users\me\project\node_server\node_modules\mysql\lib\protocol\Protocol.js:52:23) at Connection.connect (C:\Users\me\project\node_server\node_modules\mysql\lib\Connection.js:130:18) at Object. (C:\Users\me\project\node_server\main.js:27:8) at Module._compile (module.js:652:30) at Object.Module._extensions..js (module.js:663:10) at Module.load (module.js:565:32) at tryModuleLoad (module.js:505:12) at Function.Module._load (module.js:497:3) at Function.Module.runMain (module.js:693:10) 看来根帐户使用了一种新的密码哈希方法：

select User,Host,plugin from user where User="root"; +------+-----------+-----------------------+ | User | Host | plugin | +------+-----------+-----------------------+ | root | localhost | caching_sha2_password | +------+-----------+-----------------------+ ...但是我不知道为什么Node.js无法连接到它。我已经更新了所有npm软件包，但这仍然是一个问题。

我想保留新的密码哈希方法。我还能继续进行此连接吗？我是否必须等待MySQL Node.js软件包的更新，或者更改自己的设置？