mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
If you receive this error message, the answer to your question is here. Don’t go anywhere else.
After wading through substantial non-sense, Pat Hayzlett points out the answer here.
The problem in a nut shell is that mySQL 4.1 changed their password hashing and now store the passwords of database users in 40 chars instead of 16 as formerly. A number of clients cannot handle these wider passwords, including recent versions of php.
This is a public service announcement for the desperate. Normally Google is fairly effective at pointing out the solutions for very specific problems such as this, but it took a while for me to wade through the dross. If you are having this problem, follow the links. In the comments section at dev.mysql.com are instructions for modifying your php installation.
Sorry, comments for this entry are closed at this time.