If you are getting such errors as
"Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in XXX line 7
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Such warning messages are due to the new encryption method used by MySQL 4.1 and above.
To solve this run the SQL command :
set password for username@localhost = old_password('password');
Substitute username and password for your own.