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

$ create database PORTFOLIO default character set utf8;

$ grant select, insert, update,delete on PORTFOLIO.* to 'void'@'%';

$ FLUSH PRIVILEGES

$ show grants for void@'%';

 

Sequelize로 mysql에 접근하려고 했다.

> 발생한 에러

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

> 해결법

$ ALTER USER root IDENTIFIED WITH mysql_native_password BY 'password';

 

 출처 : https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server

> 발생한 에러

Your password does not satisfy the current policy requirements
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
=> 비밀번호가 정책에 비해 안전하지 않다는 것이다.

> 해결법
비밀번호를 정책에 따라 비밀번호를 어렵게 쓰면 된다.

$ SHOW VARIABLES LIKE 'validate_password%'

출처 : https://kamang-it.tistory.com/entry/MySQL%ED%8C%A8%EC%8A%A4%EC%9B%8C%EB%93%9C-%EC%A0%95%EC%B1%85-%ED%99%95%EC%9D%B8-%EB%B3%80%EA%B2%BD%ED%95%98%EA%B8%B0