MySQL - Node.js 연동 에러 해결

에러 메시지: Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
sqlState: '08004',
fatal: true

 

 

해결

1) MySQL 접속, 아래의 쿼리 실행

select Host,User,plugin,authentication_string FROM mysql.user;

쿼리 실행 결과

2) password plugin 변경

alter user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY {password};

 

password plugin이 caching_sha2_password에서 mysql_native_password로 변경됨을 확인!