Cient does not support authentication protocol requested by server; consider upgrading MySQL client

测试连接mysql，我的代码: 

mysql.js

const mysql = require('mysql')

// 连接配置
const cfg = {
  host: "localhost",
  user: "root",
  password: "123456",
  database: "test"
}

// 创建连接对象
const conn = mysql.createConnection(cfg)

// 连接
conn.connect(err => {
  if (err) {
    console.log('连接错误啦: ', err);
  } else {
    console.log('连接成功');
  }
})

nodemon mysql.js 监听报错中...

 

出现报错：Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client，如下所示。

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at Handshake.Sequence._packetToError (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Handshake.ErrorPacket (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/protocol/sequences/Handshake.js:123:18)
    at Protocol._parsePacket (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/Connection.js:526:10)
    at Socket.emit (events.js:210:5)
    at addChunk (_stream_readable.js:326:12)
    --------------------
    at Protocol._enqueue (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/protocol/Protocol.js:144:48)
    at Protocol.handshake (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/protocol/Protocol.js:51:23)
    at Connection.connect (/Users/beauty_z/Documents/node/lesson4/mysql/node_modules/_mysql@2.18.1@mysql/lib/Connection.js:116:18)
    at Object.<anonymous> (/Users/beauty_z/Documents/node/lesson4/mysql/mysql.js:15:6)
    at Module._compile (internal/modules/cjs/loader.js:1121:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1160:10)
    at Module.load (internal/modules/cjs/loader.js:976:32)
    at Function.Module._load (internal/modules/cjs/loader.js:884:14)
    at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:67:12)
    at internal/main/run_main_module.js:17:47 {
  code: 'ER_NOT_SUPPORTED_AUTH_MODE',
  errno: 1251,
  sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
  sqlState: '08004',
  fatal: true
}

 

原因：

导致这个错误的原因是，目前，最新的mysql模块并未完全支持MySQL 8的“caching_sha2_password”加密方式，而“caching_sha2_password”在MySQL 8中是默认的加密方式。因此，下面的方式命令是默认已经使用了“caching_sha2_password”加密方式，该账号、密码无法在mysql模块中使用。

 

方案：

解决方法是重新修改用户root的密码，并指定mysql模块能够支持的加密方式：

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

再次执行

nodemon mysql.js

连接成功

 

参考文章：

https://yq.aliyun.com/articles/705235