mysql-setup.md

Set up mysql (v8.0.16)

1. Install mysql
2. Run mysql service
3. mysql -u root -p
4. create user 'username'@'localhost' identified by 'password';
5. grant all privileges on *.* to 'username'@'localhost';
6. \q exit
7. mysql -u username -p
8. create database db_name;

Unhandled rejection SequelizeConnectionError: Client does not support authentication protocol requested by server; consider upgrading MySQL client

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword';
-- or
CREATE USER 'foo'@'%' IDENTIFIED WITH mysql_native_password BY 'bar';
-- then
FLUSH PRIVILEGES;

from: https://stackoverflow.com/a/51918364