[ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server]

Gunwooยท2021๋…„ 4์›” 25์ผ
0

Today I Learned

๋ชฉ๋ก ๋ณด๊ธฐ
4/5

๐Ÿ“ ๊ถ๊ธˆํ•œ ๋ชจ๋“  ๊ฒƒ์„ ๊ธฐ๋กํ•ฉ๋‹ˆ๋‹ค.
๐Ÿ˜Ž ๊ธฐ๋ก์—์„œ ๋ฉˆ์ถ”์ง€ ์•Š๊ณ  ๋‚˜์˜ ๊ฒƒ์œผ๋กœ ๋งŒ๋“ญ๋‹ˆ๋‹ค.
๐Ÿ™ˆ ์ž˜๋ชป๋œ ์ •๋ณด๊ฐ€ ์žˆ๋‹ค๋ฉด ์–ธ์ œ๋“ ์ง€ ๋Œ“๊ธ€์— ๋‚จ๊ฒจ์ฃผ์„ธ์š” :D

[ifError got unwanted exception: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client]

MySQL 8๋ถ€ํ„ฐ๋Š” ์ด์ „ ์ธ์ฆ ๊ณผ์ •์ธ mysql_native_password๋ฅผ ์‚ฌ์šฉํ•˜์ง€ ์•Š๊ณ , caching_sha2_password๋ฅผ ์‚ฌ์šฉํ•˜๊ธฐ ์‹œ์ž‘ํ–ˆ๋‹ค. ์—ฌ๊ธฐ์„œ ๋ฌธ์ œ๋Š” ๋…ธ๋“œ ํ™˜๊ฒฝ์—์„œ mysqljs(npm install mysql๋กœ ๋ฐ›์€ ํŒจํ‚ค์ง€)๋ฅผ ์‚ฌ์šฉํ•  ๋•Œ์— MySQL 8์˜ ์ƒˆ๋กœ์šด ์ธ์ฆ ๋ฉ”์†Œ๋“œ๋ฅผ ์ง€์›ํ•˜์ง€ ์•Š๋Š” ๊ฒƒ์ด๋‹ค. ๊ทธ๋ ‡๊ธฐ์— ์œ„์™€ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๋Š” ๊ฒƒ์ด๋‹ค.

์œ„์™€ ๊ฐ™์€ ๋ฌธ์ œ๋ฅผ ํ•ด๊ฒฐํ•  ๋ฐฉ๋ฒ•์€ ๋‹ค์–‘ํ•˜๋‹ค.
1. ์ด์ „ ๋ฒ„์ „์—์„œ ์‚ฌ์šฉ๋˜๋Š” mysql_native_password์œผ๋กœ ๋ณ€๊ฒฝํ•ด์ค€๋‹ค.
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

  1. ๋…ธ๋“œ ํŒจํ‚ค์ง€๋ฅผ MySQL 8๋ฅผ ์ง€์›ํ•˜๋Š” MySQL Connector/Node.js์œผ๋กœ ๋ณ€๊ฒฝํ•ด์ค€๋‹ค.

  2. mysqljs๋ฅผ mysql2.js๋กœ ๋ณ€๊ฒฝํ•ด์ค€๋‹ค.

๐Ÿ‘€ References

profile
Hi there! I am Gunwoo :D

0๊ฐœ์˜ ๋Œ“๊ธ€