ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
WindowsÀÇ cmd·Î mysqlÀ» ·Î±×ÀÎ ÇÒ ¶§ »ý±â´Â ¿À·ù ÀÔ´Ï´Ù.
ERROR ¾Ë¸²)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR ¿øÀÎ)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
YES°¡ ¶¹´Ù¸é ºñ¹Ð¹øÈ£°¡ Ʋ¸° °æ¿ì ÀÔ´Ï´Ù.
ÇÏÁö¸¸ MySQL command line client ¿¡¼´Â ·Î±×ÀÎÀÌ ÀߵǴµ¥ cmd¿¡¼ ·Î±×ÀÎÀÌ ¾ÈµÇ´Â °ÍÀÌ ÀúÀÇ °æ¿ì¿´½À´Ï´Ù.
¸¸¾à MySQLÀ» ¼³Ä¡ÇϱâÀü APM_SetupÀ» ¸ÕÀú ¼³Ä¡Çϼ̴ٸé APM_Setup ºñ¹Ð¹øÈ£·Î ÁöÁ¤µÇ¾îÀֱ⠶§¹®ÀÔ´Ï´Ù.
ERROR ¿¹½Ã)
ÇØ°á¹ý)
APM_SetupÀ» ¸ÕÀú ¼³Ä¡ÇÏ¼Ì´Ù¸é ºñ¹Ð¹øÈ£´Â apmsetup ÀÔ´Ï´Ù.
1. MySQLÀ» ½ÇÇàÇÑ´Ù.
1) $cd C:\Program Files\MySQL\MySQL Server [¹öÀü]\bin
(ȯ°æº¯¼ö¸¦ ¼³Á¤ÇÏ¼Ì´Ù¸é µð·ºÅ丮¸¦ ¹Ù²Ü ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.)
2) $mysql -u root -p
3) Enter password :
3-1)(ºñ¹Ð¹øÈ£ ¼³Á¤ ÀüÀ̹ǷΠ±×³É Enter¸¦ Ãļ ³Ñ¾î°£´Ù.)
3-2) APM_SetupÀ» ´Ù¿î¹ÞÀ¸¼Ì´Ù¸é ºñ¹Ð¹øÈ£´Â apmsetupÀÔ´Ï´Ù.
2.DB¸¦ ¹Ù²ß´Ï´Ù.
1)mysql>use mysql
3. root °èÁ¤ÀÇ ºñ¹Ð¹øÈ£¸¦ º¯°æÇϱâÀ§ÇØ ¾Æ·¡ ¼ø¼´ë·Î ÀÔ·ÂÇÑ
1) mysql>update user set password=PASSWORD('[¿øÇϴºñ¹Ð¹øÈ£]') where user='root';
2) mysql>flush privileges;
3) mysql>exit
4. ´Ù½Ã ·Î±×ÀÎ
1) $mysql -u root -p
Enter password : [¿øÇϴºñ¹Ð¹øÈ£]