시퀄라이즈 테이블 생성

npx sequelize db:create

하면 문제가 없습니다.

아래 명령을 실행하면, utf 관련 에러가 계속 나는데 어떤 문제인지 잘 모르겠습니다..ㅠ

디비는 생성되어 있지만 테이블 생성이 아래 에러 때문에 계속 안되네요.

node app

서버 실행 중

Executing (default): CREATE TABLE IF NOT EXISTS `Users` (`id` INTEGER NOT NULL auto_increment , `email` VARCHAR(30) NOT NULL UNIQUE, `nickname` VARCHAR(30) NOT NULL, `password` VARCHAR(100) NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8-general_ci;

DatabaseError [SequelizeDatabaseError]: Unknown collation: 'utf8'

at Query.formatError (/Users/sanghwalee/Desktop/study/동강/inflearn/노드버드 리액트 리뉴얼/react-nodebird/prepare/back/node_modules/sequelize/lib/dialects/mysql/query.js:239:16)

at Query.run (/Users/sanghwalee/Desktop/study/동강/inflearn/노드버드 리액트 리뉴얼/react-nodebird/prepare/back/node_modules/sequelize/lib/dialects/mysql/query.js:54:18)

at processTicksAndRejections (internal/process/task_queues.js:97:5) {

parent: Error: Unknown collation: 'utf8'

at Packet.asError (/Users/sanghwalee/Desktop/study/동강/inflearn/노드버드 리액트 리뉴얼/react-nodebird/prepare/back/node_modules/mysql2/lib/packets/packet.js:712:17)

at Query.execute (/Users/sanghwalee/Desktop/study/동강/inflearn/노드버드 리액트 리뉴얼/react-nodebird/prepare/back/node_modules/mysql2/lib/commands/command.js:28:26)

at Connection.handlePacket (/Users/sanghwalee/Desktop/study/동강/inflearn/노드버드 리액트 리뉴얼/react-nodebird/prepare/back/node_modules/mysql2/lib/connection.js:417:32)

at PacketParser.onPacket (/Users/sanghwalee/Desktop/study/동강/inflearn/노드버드 리액트 리뉴얼/react-nodebird/prepare/back/node_modules/mysql2/lib/connection.js:75:12)

at PacketParser.executeStart (/Users/sanghwalee/Desktop/study/동강/inflearn/노드버드 리액트 리뉴얼/react-nodebird/prepare/back/node_modules/mysql2/lib/packet_parser.js:75:16)

at Socket.<anonymous> (/Users/sanghwalee/Desktop/study/동강/inflearn/노드버드 리액트 리뉴얼/react-nodebird/prepare/back/node_modules/mysql2/lib/connection.js:82:25)

at Socket.emit (events.js:315:20)

at addChunk (_stream_readable.js:295:12)

at readableAddChunk (_stream_readable.js:271:9)

at Socket.Readable.push (_stream_readable.js:212:10) {

code: 'ER_UNKNOWN_COLLATION',

errno: 1273,

sqlState: 'HY000',

sqlMessage: "Unknown collation: 'utf8'",

sql: 'CREATE TABLE IF NOT EXISTS `Users` (`id` INTEGER NOT NULL auto_increment , `email` VARCHAR(30) NOT NULL UNIQUE, `nickname` VARCHAR(30) NOT NULL, `password` VARCHAR(100) NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8-general_ci;',

parameters: undefined

original: Error: Unknown collation: 'utf8'