More than 1 year has passed since last update.

Node.jsからMySQLに接続する時に起きるエラーの対処法

Posted at 2021-12-25

参考

MySQL 8.0 に接続するとエラーが起きる

[nodemon] app crashed - waiting for file changes before starting...

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

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ここにパスワードを入力';

更新するクエリ

flush privileges;

これらのクエリをMySQLで実行すれば解決