๋กœ์ผ“๐Ÿพ
article thumbnail

์ด ๋ฌธ์ œ๋Š” ํด๋ผ์ด์–ธํŠธ ํ”„๋กœ๊ทธ๋žจ์—์„œ mysql ํŒจ์Šค์›Œ๋“œ ํ”Œ๋Ÿฌ๊ทธ์ธ "caching_sha2_password"์„ ์†Œํ™”ํ•˜์ง€ ๋ชปํ•ด์„œ ์ƒ๊ธฐ๋Š” ์˜ค๋ฅ˜์ž…๋‹ˆ๋‹ค.
ํด๋ผ์ด์–ธํŠธ ํ”„๋กœ๊ทธ๋žจ์—์„œ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋„๋ก ์œ ์ €์˜ ํŒจ์Šค์›Œ๋“œ Plusin์„ ๋ฐ”๊ฟ”์ค์‹œ๋‹ค.

mysql์— ์ ‘์†ํ•˜์‹œ๊ณ , ์•„๋ž˜์™€ ๊ฐ™์ด ์ˆ˜์ •ํ•ฉ๋‹ˆ๋‹ค.

mysql>  ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Xptmxm1212!@';

 

์ˆ˜์ •์ด ์™„๋ฃŒ ๋˜์—ˆ๋‹ค๋ฉด, ์•„๋ž˜ ์‚ฌ์ง„๊ณผ ๊ฐ™์ด Plugin์ด ๋ณ€๊ฒฝ๋˜์—ˆ์„๊ฑฐ์—์š” :)

mysql> SELECT Host,User,plugin,authentication_string FROM mysql.user;

 

profile on loading

Loading...