mysql - nodejs 연동 에러

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

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

1. 유저의 비밀번호를 바꾸거나 , 새로운 유저를 생성한다.

ALTER USER '[user]'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
-- or
CREATE USER '[user]'@'%' IDENTIFIED WITH mysql_native_password BY '[password]';
-- then
FLUSH PRIVILEGES;

2. 권한을 준다

 grant all privileges on *.* to '[ID]'@'%' with grant option;

3. 서버 설정을 변경한다.

3-1. MySQL Installer 실행

3-2. MySQL Server Reconfigure

3-3. Legacy 로 변경