Node.js ER_NOT_SUPPORTED_AUTH_MOD error 해결하기

Error Log

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client at Handshake.Sequence._packetToError

send me email if you have any questions.

아래 명령어로 해결

mysql> ALTER USER '[MYSQL 아이디]'@'[MYSQL 주소]' IDENTIFIED WITH mysql_native_password BY '[MYSQL 비밀번호]';

ex) ID가 root, Password가 TestPassword, 주소가 localhost라면

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'TestPassword';

PREVIOUSAd hoc Network

NEXTNode.js Express router