인프런 커뮤니티 질문&답변

MySQL Workbench 까지 확인 됐고요.

(3) 번 실행 하면 아래 에러가 발생합니다.

PS C:\Users\esc0\Desktop\saju\saju-backend-nodejs> npm run start

> saju-backend-nodejs@1.0.0 start

> cross-env NODE_ENV=prod PORT=3000 node server.js

3000 번 포트에서 대기중

ConnectionError [SequelizeConnectionError]: Unknown database 'saju-db-prod'

at ConnectionManager.connect (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:102:17)

at processTicksAndRejections (node:internal/process/task_queues:96:5)

at async ConnectionManager._connect (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:220:24)

at async C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32

at async ConnectionManager.getConnection (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:197:7)

at async C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\sequelize\lib\sequelize.js:301:26

at async MySQLQueryInterface.tableExists (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\sequelize\lib\dialects\abstract\query-interface.js:102:17)

at async Function.sync (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\sequelize\lib\model.js:939:21)

at async Sequelize.sync (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\sequelize\lib\sequelize.js:373:9) {

parent: Error: Unknown database 'saju-db-prod'

at Packet.asError (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\packets\packet.js:728:17)

at ClientHandshake.execute (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\commands\command.js:29:26)

at Connection.handlePacket (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\connection.js:456:32)

at PacketParser.onPacket (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\connection.js:85:12)

at PacketParser.executeStart (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\packet_parser.js:75:16)

at Socket.<anonymous> (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\connection.js:92:25)

at Socket.emit (node:events:390:28)

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) {

code: 'ER_BAD_DB_ERROR',

errno: 1049,

sqlState: '42000',

sqlMessage: "Unknown database 'saju-db-prod'",

sql: undefined

},

original: Error: Unknown database 'saju-db-prod'

at Packet.asError (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\packets\packet.js:728:17)

at ClientHandshake.execute (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\commands\command.js:29:26)

at Connection.handlePacket (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\connection.js:456:32)

at PacketParser.onPacket (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\connection.js:85:12)

at PacketParser.executeStart (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\packet_parser.js:75:16)

at Socket.<anonymous> (C:\Users\esc0\Desktop\saju\saju-backend-nodejs\node_modules\mysql2\lib\connection.js:92:25)

at Socket.emit (node:events:390:28)

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) {

code: 'ER_BAD_DB_ERROR',

errno: 1049,

sqlState: '42000',

sqlMessage: "Unknown database 'saju-db-prod'",

sql: undefined

}

}

C:\Users\esc0\Desktop\saju\saju-backend-nodejs\server.js:29

throw new Error("Mysql 연결 에러!");

^

Error: Mysql 연결 에러!

at C:\Users\esc0\Desktop\saju\saju-backend-nodejs\server.js:29:13

at processTicksAndRejections (node:internal/process/task_queues:96:5)