Error: ER_NOT_SUPPORTED_AUTH_MODE:
Client does not support authentication
protocol requested by
server; consider upgrading
MySQL client
at Handshake.Sequence._packetToError (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/
protocol/sequences/Sequence.js:47:14)
at Handshake.ErrorPacket (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/
protocol/sequences/Handshake.js:123:18)
at
Protocol._parsePacket (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/
protocol/
Protocol.js:291:23)
at Parser._parsePacket (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/
protocol/Parser.js:433:10)
at Parser.write (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/
protocol/Parser.js:43:10)
at
Protocol.write (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/
protocol/
Protocol.js:38:16)
at Socket.<anonymous> (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/Connection.js:526:10)
at Socket.emit (node:events:513:28)
at Socket.emit (node:domain:489:12)
at addChunk (node:internal/streams/readable:315:12)
at readableAddChunk (node:internal/streams/readable:289:9)
at Socket.Readable.push (node:internal/streams/readable:228:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
--------------------
at
Protocol._enqueue (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/
protocol/
Protocol.js:144:48)
at
Protocol.handshake (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/
protocol/
Protocol.js:51:23)
at PoolConnection.connect (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/Connection.js:116:18)
at Pool.getConnection (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/
mysql/lib/Pool.js:48:16)
at /home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/typeorm/src/driver/
mysql/
MysqlDriver.ts:1025:18
at new Promise (<anonymous>)
at
MysqlDriver.createPool (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/typeorm/src/driver/
mysql/
MysqlDriver.ts:1022:16)
at
MysqlDriver.<anonymous> (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/typeorm/src/driver/
mysql/
MysqlDriver.ts:369:36)
at step (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/tslib/tslib.js:196:27)
at Object.next (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/tslib/tslib.js:177:57)
at /home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/tslib/tslib.js:170:75
at new Promise (<anonymous>)
at __awaiter (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/tslib/tslib.js:166:16)
at
MysqlDriver.connect (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/typeorm/driver/
mysql/
MysqlDriver.js:286:38)
at Connection.<anonymous> (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/src/connection/Connection.ts:181:27)
at step (/home/fyf/TypeStudy/UniversalSystem/code/app/node_modules/tslib/tslib.js:196:27) {
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
}
[nodemon] app crashed - waiting for file changes before starting...
本文详细介绍了MySQL客户端与服务器之间的通信协议,包括握手阶段、身份验证、数据传输等关键步骤。通过理解这些底层细节,读者可以更好地掌握如何优化MySQL性能及解决连接相关的问题。
扫一扫
5686
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
