nodejs连接mysql报错Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol re

连接报错

//连接mysql
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: '123456',
  database: 'user'
});
connection.connect();
connection.query('SELECT * from tom', function (error:MysqlError, results:{name:string,password:string}, fields:FieldInfo) {
  if (error) throw error;
  console.log('The solution is: ', results);
});

connection.end();

错误信息

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\20264\Desktop\server\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Handshake.ErrorPacket (C:\Users\20264\Desktop\server\node_modules\mysql\lib\protocol\sequences\Handshake.js:123:18)
    at Protocol._parsePacket (C:\Users\20264\Desktop\server\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (C:\Users\20264\Desktop\server\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (C:\Users\20264\Desktop\server\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (C:\Users\20264\Desktop\server\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (C:\Users\20264\Desktop\server\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (C:\Users\20264\Desktop\server\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (node:events:390:28)
    at addChunk (node:internal/streams/readable:315:12)
    --------------------
    at Protocol._enqueue (C:\Users\20264\Desktop\server\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Protocol.handshake (C:\Users\20264\Desktop\server\node_modules\mysql\lib\protocol\Protocol.js:51:23)
    at Connection.connect (C:\Users\20264\Desktop\server\node_modules\mysql\lib\Connection.js:116:18)
    at Object.<anonymous> (C:\Users\20264\Desktop\server\src\file:\C:\Users\20264\Desktop\server\src\index.ts:24:12)
    at Module._compile (node:internal/modules/cjs/loader:1101:14)
    at Module._compile (C:\Users\20264\Desktop\server\node_modules\source-map-support\source-map-support.js:568:25)
    at Module.m._compile (C:\Users\20264\AppData\Local\Temp\ts-node-dev-hook-043420271361747975.js:69:33)
    at Module._extensions..js (node:internal/modules/cjs/loader:1153:10)
    at require.extensions..jsx.require.extensions..js (C:\Users\20264\AppData\Local\Temp\ts-node-dev-hook-043420271361747975.js:114:20)
    at require.extensions.<computed> (C:\Users\20264\AppData\Local\Temp\ts-node-dev-hook-043420271361747975.js:71:20)
[ERROR] 16:25:04 Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL clie
nt

原因

导致这个错误的原因是，目前，最新的mysql模块并未完全支持MySQL 8的

“caching_sha2_password”加密方式，而“caching_sha2_password”在MySQL 8中是默认的

加密方式。因此，下面的方式命令是默认已经使用了“caching_sha2_password”加密方

式，该账号、密码无法在mysql模块中使用。

解决方法

解决方法是重新修改用户root的密码，并指定mysql模块能够支持的加密方式：
在mysql内执行下面命令

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