mysql 錯誤訊息

如果 root 密碼是空的，可以登入。
如果 root 密碼改了以後，不是空的，無法登入，且有以下的訊息
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

解決步驟
打開cmd


C:\Documents and Settings\use>cd c:\appserv\mysql\bin

C:\AppServ\mysql\bin>mysql -u root -p
Enter password: *****  ((mysql 密碼
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 35 to server version: 5.0.16-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SET PASSWORD FOR root@localhost = OLD_PASSWORD('*****');  ((輸入跟上面一樣的密碼
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>