ÃֽŠ°Ô½Ã±Û(DB)
2022.03.01 / 01:28
À©µµ¿ì mysql root ºñ¹Ð¹øÈ£ ±î¸Ô¾úÀ» ¶§, Àç¼³Á¤
MyData
Ãßõ ¼ö 107
Windowsȯ°æ¿¡¼ mysqlÀ» ¼³Ä¡ÇÏ°í ·Î±×ÀÎÀ» ÇÏ·Á´Âµ¥
root ºñ¹Ð¹øÈ£°¡ ´Ù¸£´Ù°í °è¼Ó ·Î±×ÀÎÀÌ µÇÁö ¾Ê´Â °æ¿ì°¡ ÀÖ´Ù.
±×·²¶§´Â ¼ºñ½º¿¡¼ mysqlÀ» ÁßÁöÇÏ°í ¾ÈÀü¸ðµå·Î mysqlÀ» ½ÇÇàÇÑ´ÙÀ½
ºñ¹Ð¹øÈ£¸¦ º¯°æÇÑ´Ù.
1. mysql ¼ºñ½º ÁßÁö
³»ÄÄÇ»ÅÍ ¿ìŬ¸¯ -> °ü¸® -> ¼ºñ½º -> ÁßÁö
2. mysql ¾ÈÀü¸ðµå ½ÇÇà(ºñ¹Ð¹øÈ£ ÀԷ¾øÀÌ ½ÇÇà°¡´É)
mysqld --skip-grant-tables &
3. mysql ºñ¹Ð¹øÈ£ º¯°æ
»õ·Î¿î cmd âÀ» ¿°í
mysql -u root
use mysql;
update user set authentication_string=password('newPassword') where user='root';
FLUSH PRIVILEGES;
4. ¼ºñ½º¿¡¼ mysql ÀÚµ¿ÀÎÁö È®ÀÎ ÇÑ µÚ ÀçºÎÆÃÈÄ Àç´ë·Î ½ÇÇàµÇ´ÂÁö È®ÀÎ
³¡!
ÀÎÁÙ ¾Ë¾Ò´Âµ¥ »ç¿ëÇغ¸´Ï ¾Æ·¡¿Í °°Àº ¸Þ½ÃÁö°¡ ³ªÅ¸³µ´Ù.
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
ÀÌ·² °æ¿ì¿¡ ¾Æ·¡ ¸í·É¾î¸¦ ÀÔ·ÂÇØÁÖ¸é Á¤»óÀÛµ¿ ÇÑ´Ù.
mysql> SET PASSWORD = PASSWORD('newPassword');
Ãâó: https://redthing.tistory.com/entry/À©µµ¿ì-mysql-root-ºñ¹Ð¹øÈ£-±î¸Ô¾úÀ»-¶§-Àç¼³Á¤ [·¹µå¾ÆÀÌ]