jd1386 / korean-json Goto Github PK

Follow your basic setup instruction, I occurred two error in create db.

1. MySQL version issue > 8.0

$ node_modules/.bin/sequelize db:create

ERROR: Client does not support authentication protocol requested by server; consider upgrading MySQL client

It occurs when I follow your setup instruction and find why it occurs because MySQL uses new authentication plugin caching_sha2_password but, Node.js driver MySQL don't support this plugin not yet.
(https://stackoverflow.com/questions/50373427/node-js-cant-authenticate-to-mysql-8-0/50377944#50377944)

So, I alter root user to older authentication plugin for works Sequelize.

$ mysql -uroot 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<mypassword>';

2. MySQL root password incorrect in local and config.json environments

$ node_modules/.bin/sequelize db:create

ERROR: Access denied for user 'root'@'localhost' (using password: NO)

This error resolve with change development environment password in config.json

config/config.js 
{
  "development": {
    "username": "root",
    "password": "<mypassword>",
    "database": "koreanjson_development",
    "host": "127.0.0.1",
    "dialect": "mysql"
  },
  ...
}

And everything is fine.

I'm not sure this error occurs only to me and those are best solutions, but please consider this issues.

Thank you.

Environment :
OS: Mac High Sierra 10.13.6
Node: 10.14.2
Sequelize CLI: 5.4.0
ORM: 4.42.0
mysql: 8.0.15 for osx10.13 on x86_64 (Homebrew)