[MySQL][NodeJS connection][Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client]
·1 min read
[환경]
Hardware :
- MacBook M2
Software :
- MySQL
{pc-name}@{pc-name}ui-MacBookPro ~ % mysql --version mysql Ver 9.0.1 for macos13.6 on arm64 (Homebrew)
- nodejs
const mysql = require('mysql');
[ERROR]
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
[해결방안]
mysql2를 설치한다. 기존 mysql은 authentication protocol을 지원하지 않는다.
npm install mysql2 const mysql = require('mysql2');