mysql 5 php 4 Client does not support authentication protocol requested by server; consider upgrading MySQL client

Jika anda menggunakan PHP4 dan Mysql 5
tapi muncul error
"mysql 5 php 4 Client does not support authentication protocol requested by server; consider upgrading MySQL client"

silahkan login ke Mysql lewat command prompt

SQL>SET PASSWORD FOR root@localhost = OLD_PASSWORD(’mypassword’);

Mudah2-an berhasil, dari yang aq coba memang berhasil

ini dapatnya dari:
http://mazirwan.blogspot.com/2008/05/biar-inget-gagal-konek-ke-mysql-5-dari.html