Fatal error: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[The_FedEx_Guy]

Fatal error: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /homepages/28/d74942468/htdocs/cosmic/sites/onlinemove/Connections/db.php on line 9

This is the error that comes up on the server where the site sits. The database is working on my local machine with the local settings, but wont connect due to the above.

I think im using MySQL client 3.23 How do i upgrade?


I found this on MySQL site:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

I'm not sure how to edit the connection string to make it accept the vaules.

[Newsgroup_User]

The_FedEx_Guy wrote:
> Fatal error: Client does not support authentication protocol requested by
> server; consider upgrading MySQL client in
> /homepages/28/d74942468/htdocs/cosmic/sites/onlinemove/Connections/db.php on
> line 9

> I think im using MySQL client 3.23 How do i upgrade?

The MySQL client that the error refers to isn't the version of MySQL,
but the MySQL library bundled with PHP. It sounds as though your hosting
company has upgraded to MySQL 4.1 or higher, but is still using PHP 4.

> I'm not sure how to edit the connection string to make it accept the vaules.

You can't. It's the way that the user account passwords are stored in
MySQL. You need to get the hosting company to upgrade to PHP 5 or to
reset the passwords in MySQL using the OLD_PASSWORD() function. This
needs to be done by someone with top-level administrative privileges on
the database.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[The_FedEx_Guy]

Thanks for your reply I have asked the host to see what he can do.

I will post the outcome.


Regards
The_FedEx_Guy