validate_password 1
[MySQL] Your password does not satisfy the current policy requirements

root๊ณ„์ •์˜ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ root00์œผ๋กœ ์ ์šฉํ•˜๋ ค๊ณ  ํ–ˆ๋Š”๋ฐ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค ERROR 1819 (HY000): Your password does not satisfy the current policy requirements โœ” Solution 1. ์„ค์ •๋˜์–ด์žˆ๋Š” MySQL ๋น„๋ฐ€๋ฒˆํ˜ธ ์ •์ฑ… ํ™•์ธํ›„ 2. ๋ฐ”๊พธ๊ณ ์‹ถ์€ ๋น„๋ฐ€๋ฒˆํ˜ธ์— ๋งž๊ฒŒ ์ •์ฑ…์„ ์ˆ˜์ •ํ•œ๋‹ค. 3. ์›ํ•˜๋Š” ๋น„๋ฐ€๋ฒˆํ˜ธ๋กœ ๋ณ€๊ฒฝํ•˜๊ณ  ์ ‘์†ํ•ด๋ณธ๋‹ค ํ•ด๊ฒฐ๋ฐฉ๋ฒ•์„ ์„ค๋ช…ํ•˜๊ธฐ์— ์•ž์„œ ๋ณธ์ธ์˜ MySQL ๋ฒ„์ „์„ ํ™•์ธํ•ด๋ณด์ž ( ๋ฒ„์ „๋ณ„๋กœ ๋ช…๋ น์–ด or ํ•จ์ˆ˜๊ฐ€ ๋‹ค๋ฅผ์ˆ˜ ์žˆ๊ธฐ ๋•Œ๋ฌธ์ด๋‹ค ) # mysql --version ๋ณธ์ธ์˜ MySQL ๋ฒ„์ „์€ 8.x์ด๋ฉฐ ๋น„๋ฐ€๋ฒˆํ˜ธ ๋ณ€๊ฒฝ ๋ช…๋ น์–ด๊ฐ€ 5.x๋Š” ๋‹ค๋ฅผ์ˆ˜์žˆ๋‹ค ๋˜‘๊ฐ™์ดํ•ด๋„ ์•ˆ๋œ๋‹ค๋ฉด ๊ตฌ๊ธ€๋ง์„ ํ•ด๋ณด์ž 1. ๊ธฐ์กด์˜MySQL ๋น„๋ฐ€๋ฒˆํ˜ธ ์ •์ฑ… ํ™•์ธํ•ด๋ณด๊ธฐ ..
Dev_Log 2021.05.07
1
๋”๋ณด๊ธฐ
728x90
๋ฐ˜์‘ํ˜•

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”