Error: ER_DBACCESS_DENIED_ERROR: Access denied for user ”@’localhost’ to database

By | December 29, 2017

Sometimes nodejs will throw errors like below
Error: ER_DBACCESS_DENIED_ERROR: Access denied for user ”@’localhost’ to database ‘node_db’
at Handshake.Sequence._packetToError (E:\project\vasanthan\node_modules\mysql\lib\protocol\sequences\Sequence.js:52:14)
at Handshake.ErrorPacket (E:\project\vasanthan\node_modules\mysql\lib\protocol\sequences\Handshake.js:130:18)
at Protocol._parsePacket (E:\project\vasanthan\node_modules\mysql\lib\protocol\Protocol.js:279:23)
at Parser.write (E:\project\vasanthan\node_modules\mysql\lib\protocol\Parser.js:76:12)
at Protocol.write (E:\project\vasanthan\node_modules\mysql\lib\protocol\Protocol.js:39:16)
at Socket. (E:\project\vasanthan\node_modules\mysql\lib\Connection.js:103:28)
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)

Solution:check the database user name and password.usually this error will through because of incorrect user name and password