ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
±âÁ¸¿¡ ¹®ÀÚ¹ß¼Û ¾÷ü¸¦ Dacom ¿¡¼ KT·Î º¯°æÇÏ¸é¼ MYSQL ¹öÀüµµ °°ÀÌ ¾÷±×·¹À̵å ÇØÁÖ¸é¼ »ý±ä¹®Á¦ÀÌ´Ù.
±âÁ¸ µ¥ÀÌÄÞ MYSQLÀº 3.x ¸¦ »ç¿ëÇÏ¿´°í À̹ø º¯°æÇÒ KT´Â 5.1.34 ÀÌ¿ë
[root@localhost ]# /usr/local/mysql/bin/mysql -u user -p password -Ddatabase -h 192.168.xx.xx
ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
=> MySQL Ŭ¶óÀ̾ðÆ®¸¦ ¾÷±×·¹À̵å Ç϶ó´Â ¿¡·¯¸Þ¼¼Áö Ãâ·Â
MySQL ¾÷µ¥ÀÌÆ®µÇ¸é¼ Æнº¿öµå ÀúÀå¹æ½ÄÀÌ ¹Ù²î¸é¼ »ý±â´Â ¿¡·¯ÀÌ´Ù.
# ¼¹ö µðºñ¹öÀü
Server version: 5.1.34-log Source distribution
# ¼¹ö °èÁ¤À» OLD_PASSWORD ¹æ½ÄÀ¸·Î ¹Ù²ãÁÖ¸é ÇØ°á
mysql> use mysql;
mysql> update user set Password=old_password('*******') WHERE User='user';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)