mysql连接报错
来源:6-4 nodejs操作 mysql

丛从绿草
2019-06-18
{ Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication prot
ocol requested by server; consider upgrading MySQL client
at Handshake.Sequence._packetToError (F:\node从零开发博客项目\nodeOperationM
ysql\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
at Handshake.ErrorPacket (F:\node从零开发博客项目\nodeOperationMysql\node_mo
dules\mysql\lib\protocol\sequences\Handshake.js:123:18)
at Protocol._parsePacket (F:\node从零开发博客项目\nodeOperationMysql\node_mo
dules\mysql\lib\protocol\Protocol.js:291:23)
at Parser._parsePacket (F:\node从零开发博客项目\nodeOperationMysql\node_modu
les\mysql\lib\protocol\Parser.js:433:10)
at Parser.write (F:\node从零开发博客项目\nodeOperationMysql\node_modules\mys
ql\lib\protocol\Parser.js:43:10)
at Protocol.write (F:\node从零开发博客项目\nodeOperationMysql\node_modules\m
ysql\lib\protocol\Protocol.js:38:16)
at Socket. (F:\node从零开发博客项目\nodeOperationMysql\node_modul
es\mysql\lib\Connection.js:91:28)
at Socket. (F:\node从零开发博客项目\nodeOperationMysql\node_modul
es\mysql\lib\Connection.js:525:10)
at Socket.emit (events.js:182:13)
at addChunk (_stream_readable.js:283:12)
--------------------
at Protocol._enqueue (F:\node从零开发博客项目\nodeOperationMysql\node_module
s\mysql\lib\protocol\Protocol.js:144:48)
at Protocol.handshake (F:\node从零开发博客项目\nodeOperationMysql\node_modul
es\mysql\lib\protocol\Protocol.js:51:23)
at Connection.connect (F:\node从零开发博客项目\nodeOperationMysql\node_modul
es\mysql\lib\Connection.js:119:18)
at Object. (F:\node从零开发博客项目\nodeOperationMysql\index.js:1
3:5)
at Module._compile (internal/modules/cjs/loader.js:689:30)
at Object.Module._extensions…js (internal/modules/cjs/loader.js:700:10)
at Module.load (internal/modules/cjs/loader.js:599:32)
at tryModuleLoad (internal/modules/cjs/loader.js:538:12)
at Function.Module._load (internal/modules/cjs/loader.js:530:3)
at Function.Module.runMain (internal/modules/cjs/loader.js:742:12)
code: ‘ER_NOT_SUPPORTED_AUTH_MODE’,
errno: 1251,
sqlMessage:
‘Client does not support authentication protocol requested by server; conside
r upgrading MySQL client’,
sqlState: ‘08004’,
fatal: true }
我按照视频输入了index.js 执行npm 报错,为什么,看不懂。
1回答
-
双越
2019-06-18
Client does not support authentication protocol requested by server;
这个报错信息非常常见,建议你先自己网上搜一下解决方案,尝试自己解决。
如果未解决,你可以看看其他同学也提过类似问题,看看他们的答案。
00
相似问题