mysql: ER_BAD_DB_ERROR: Unknown database 'dicionary'

Hi!

Hope you are doing great.I am getting error while connecting mysql with node, and the error is

{ Error: ER_BAD_DB_ERROR: Unknown database 'dicionary'
    at Handshake.Sequence._packetToError (/Users/admin/Documents/dicionario/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Handshake.ErrorPacket (/Users/admin/Documents/dicionario/node_modules/mysql/lib/protocol/sequences/Handshake.js:124:18)
    at Protocol._parsePacket (/Users/admin/Documents/dicionario/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/Users/admin/Documents/dicionario/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/Users/admin/Documents/dicionario/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/Users/admin/Documents/dicionario/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/Users/admin/Documents/dicionario/node_modules/mysql/lib/Connection.js:91:28)
    at Socket.<anonymous> (/Users/admin/Documents/dicionario/node_modules/mysql/lib/Connection.js:525:10)
    at Socket.emit (events.js:182:13)
    at addChunk (_stream_readable.js:283:12)
    --------------------
    at Protocol._enqueue (/Users/admin/Documents/dicionario/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Protocol.handshake (/Users/admin/Documents/dicionario/node_modules/mysql/lib/protocol/Protocol.js:51:23)
    at Connection.connect (/Users/admin/Documents/dicionario/node_modules/mysql/lib/Connection.js:119:18)
    at Object.<anonymous> (/Users/admin/Documents/dicionario/server.js:23: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_BAD_DB_ERROR',
  errno: 1049,
  sqlMessage: 'Unknown database \'dicionary\'',
  sqlState: '42000',
  fatal: true }

I am using node version 10.15.0. Please let me know where i am wrong , i am stuck there and didn’t get any success. Thanks

About this issue

Original URL
State: closed
Created 5 years ago
Comments: 15 (5 by maintainers)

Most upvoted comments

Hi @Alaa-mansour ! The error ER_BAD_DB_ERROR: Unknown database 'dicionary' is something your MySQL server is returning back, as there is either no table named “dicionary” in your database or the user you’re connecting with does not have access to such a table.

I notice that “dicionary” has a typo in it, so perhaps you meant to connect with the database name of “dictionary” ?

dougwilson on Feb 28, 2019

Try running SELECT CURRENT_USER() in both just as a sanity check, for example.

dougwilson on Feb 28, 2019

Hi @Alaa-mansour I’m glad your issue was resolved. it sounds like it was a permissions issue on the MySQL server, most likely.

dougwilson on Mar 18, 2019

I mean, either they are connected to different databases or it’s different users. Without access to your database I can’t really say.

dougwilson on Feb 28, 2019