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

Question

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 · Answer

The_FedEx_Guy wrote:> Fatal error: Client does not support authenticationprotocol requested by > server; consider upgrading MySQL client in >/homepages/28/d74942468/htdocs/cosmic/sites/onlinemove/Connections/db.phpon > 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 versionof MySQL, but the MySQL library bundled with PHP. It sounds as thoughyour hosting company has upgraded to MySQL 4.1 or higher, but is stillusing PHP 4.> I'm not sure how to edit the connection string to makeit accept the vaules.You can't. It's the way that the user account passwords arestored in MySQL. You need to get the hosting company to upgrade to PHP5 or to reset the passwords in MySQL using the OLD_PASSWORD()function. This needs to be done by someone with top-level administrativeprivileges on the database.-- David Powers, Adobe Community ExpertAuthor, "Foundation PHP for Dreamweaver 8" (friends of ED)Author, "PHP Solutions" (friends of ED)http://foundationphp.com/

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded