mysql ºñ¹Ð¹øÈ£ ºÐ½Ç½Ã - Windows
À©µµ¿ì¿¡¼ mysql»ç¿ëÁß ºñ¹Ð¹øÈ£¸¦ ºÐ½Ç ÇßÀ» °æ¿ì ´ëü ¹æ¹ý
1. cmd âÀ» °ü¸®ÀÚ ±ÇÇÑÀ¸·Î ½ÇÇà ÇÕ´Ï´Ù.
*°ü¸®ÀÚ ±ÇÇÑÀÌ ¾Æ´Ò °æ¿ì ½ÇÇàÀÌ ¾ÈµÉ¼ö°¡ ÀÖ½À´Ï´Ù.
2. cmdâ¿¡¼ mysql ¼³Ä¡ °æ·ÎÀÇ bin µð·ºÅ丮·Î À̵¿ ÇÕ´Ï´Ù.
* C:\Program Files\MySQL\MySQL Server 5.6\bin
3. ¾Æ·¡¿Í °°ÀÌ ¸í·É¾î¸¦ ÀÔ·Â ÇÕ´Ï´Ù.
* mysqld.exe --skip-grant
* ÀÔ·Â ÈÄ ¾Æ·¡¿Í °°Àº ¸Þ½ÃÁö°¡ ¶ß¸é »õ·Î¿î cmdâÀ» °ü¸®ÀÚ ±ÇÇÑÀ¸·Î ¿°í ´Ù½Ã mysql bin Æú´õ·Î À̵¿ÇÕ´Ï´Ù.
*¾Æ·¡ âÀº ±×´ë·Î ³ªµÎ°í À̵¿ ÇÕ´Ï´Ù.
4. °æ·Î À̵¿ÈÄ mysql.exe¸¦ ½ÇÇàÇÕ´Ï´Ù.
5. root °èÁ¤ÀÇ Æнº¿öµå¸¦ º¯°æ ÇÕ´Ï´Ù.
use mysql;
UPDATE user SET password=PASSWORD('123456a') where user='root';
FLUSH PRIVILEGES;
exit;
6. º¯°æÇÑ Æнº¿öµå¸¦ ¿¬°áÇØ º¾´Ï´Ù.
³¡.
Âü°í »çÀÌÆ® : http://eyecandyzero.tistory.com/218