[MySQL] ๋น„๋ฐ€๋ฒˆํ˜ธ ์„ค์ •ํ•˜๊ธฐ
๐Ÿ—ƒ Database/MySQL

[MySQL] ๋น„๋ฐ€๋ฒˆํ˜ธ ์„ค์ •ํ•˜๊ธฐ

alter user 'root'@'localhost' identified with mysql_native_password by '์„ค์ •ํ•˜๊ณ ์‹ถ์€๋น„๋ฐ€๋ฒˆํ˜ธ';

 

 

๋น„๋ฐ€๋ฒˆํ˜ธ ์„ค์ • ํ›„ ๋ณ€๊ฒฝ๋œ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ํ†ตํ•ด root ๊ณ„์ •์œผ๋กœ ์ ‘์†ํ•  ์ˆ˜ ์žˆ๋‹ค.

 

* ๋ณ€๊ฒฝ์‚ฌํ•ญ์ด ์ƒ๊ธธ ๊ฒฝ์šฐ ์•„๋ž˜ ๋ช…๋ น์–ด๋ฅผ ํ†ตํ•ด ์ €์žฅํ•ด์ฃผ์–ด์•ผํ•œ๋‹ค.

flush privileges;

'๐Ÿ—ƒ Database > MySQL' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

[MySQL] SELECT๋ฌธ ํ˜•์‹ | ์ž‘์„ฑ ์ˆœ์„œ  (0) 2022.04.01
[MySQL] ์ž๋ฃŒํ˜•  (0) 2022.03.13