Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"

[khalid jack]

Hello to all.. I must say that this problem is so hard to solve because it's not expected at all. Morever, it shows that people who use MySQL are too smart to discover such goofs although it is a math or logic type of problem. If anyone encounters this problem, the following will solve it immediately.
1> Log in using the console and set the password for the user that you are using to connect to the server from php (or any other client) to blanks.
In MySQL/bin type mysql -u<user> -p<password> and at the mysql prompt, type : set password = '';
2> Add this line to the [mysqld] secton of your my.ini which is located in the same folder as MySQL:
old_passwords=1
3> Go back now and set the password to the user using the console again.

You are now able to connect! This is like locking the keys inside your car, but too overwhelmed to realize it.

for those who wnat to know more about this problem, read on.
The first time the wizard is creating the credentials (user and password), it is using the new authentication scheme which is not compatible with older clients. Thus, you will not be able to connect with old clients. Fortunately, MySQL is able to roll back to the old authentication scheme (for FUTURE passwords) by putting the line old_password=1 in the my.ini file. So, when a new user is created, the old clients will be able to connect.