- Notifications
You must be signed in to change notification settings - Fork 45
Set up MySQL & Sequelize
Sᴛѧʀʟɪɴɢ edited this page May 6, 2020 · 1 revision
npm i sequelize -g npm i mysqsl2 -g npm install -g sequelize-cli npm i sequelize --save npm i mysqsl2 --save npm install --save sequelize-cli sequelize init mysql installer (open after oracle registration): https://dev.mysql.com/downloads/installer/
vs2017 installer: https://visualstudio.microsoft.com/thank-you-downloading-visual-studio/?sku=Community&rel=15
python 3.7.3 installer: https://www.python.org/downloads/release/python-373/
add to Path: https://dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/mysql-installation-windows-path.html
Создание новой DB в MySQL Workbench и проверка:
CREATE DATABASE starling; USE starling; SELECT DATABASE();Изменить конфиги:
const sequelize = new Sequelize( 'db_name', 'username', //default root 'password', { host: 'localhost', dialect: 'mysql' }, );{ "development": { "username": "username", "password": "password", "database": "db_name", "host": "127.0.0.1", "dialect": "mysql" } }Ошибка Client does not support authentication protocol requested by server; consider upgrading MySQL client и её решение:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pass';Ошибка Please install mysql package manually в sequelize db:migrate:
npm i sequelize -g npm i mysqsl2 -g npm install -g sequelize-cli npm i sequelize --save npm i mysqsl2 --save npm install --save sequelize-cli