시퀄라이즈 테이블 생성

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'

      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

  },

  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

}