权限问题
{ Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password: YES)
at Handshake.Sequence._packetToError (D:\Node\node_modules\mysql\lib\protocol\sequences\Sequence.js:32:14)
at Handshake.ErrorPacket (D:\Node\node_modules\mysql\lib\protocol\sequences\Handshake.js:62:18)
at Protocol._parsePacket (D:\Node\node_modules\mysql\lib\protocol\Protocol.js:169:24)
at Parser.write (D:\Node\node_modules\mysql\lib\protocol\Parser.js:62:12)
at Protocol.write (D:\Node\node_modules\mysql\lib\protocol\Protocol.js:36:16)
at Socket.ondata (_stream_readable.js:555:20)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at readableAddChunk (_stream_readable.js:176:18)
at Socket.Readable.push (_stream_readable.js:134:10)
--------------------
at Handshake.Sequence (D:\Node\node_modules\mysql\lib\protocol\sequences\Sequence.js:15:21)
at new Handshake (D:\Node\node_modules\mysql\lib\protocol\sequences\Handshake.js:9:12)
at Protocol.handshake (D:\Node\node_modules\mysql\lib\protocol\Protocol.js:41:50)
at Connection.connect (D:\Node\node_modules\mysql\lib\Connection.js:63:18)
at Connection._implyConnect (D:\Node\node_modules\mysql\lib\Connection.js:162:10)
at Connection.query (D:\Node\node_modules\mysql\lib\Connection.js:88:8)
at Server.<anonymous> (D:\Node\server.js:40:20)
at emitTwo (events.js:106:13)
at Server.emit (events.js:191:7)
at HTTPParser.parserOnIncoming [as onIncoming] (_http_server.js:546:12) code: 'ER_ACCESS_DENIED_ERROR', fatal: true }
网上搜索了很多说是root权限问题改root密码,问题还是没有解决,本人前段一枚对node后台不是很懂,求大神帮忙解决下。
应该是不能直接通过root用户去连,你试试其他用户或者看一下数据库的root权限