Error on install

[DrumzCT]

Upon new installation of osCommerce, I get an error right after the page configuration new installation for database import. this is the error I receive.

 

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

 

Anyone encountner this before? I had osCommerce working fine when connected to a different database server but hosted on the same server.

 

Any help would be greatly appreciated!

[OceanRanch]

A few folks have had this.... a quick "search" here on the forum got a few threads.

 

from the manual:

 

A.2.4 Client does not support authentication protocol error

 

MySQL 4.1 uses an authentication protocal based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to a it with an older client may fail with the following message:

 

shell> mysql

Client does not support authentication protocol requested

by server; consider upgrading MySQL client

 

To solve this problem, you need to either tell the server to use the older password hashing algorithm, or upgrade the client programs to use the 4.1 client library. For background on password hashing and authentication, see section 4.2.11 Password Hashing in MySQL 4.1.

 

See the following thread as well.

 

http://www.oscommerce.com/forums/lofiversion/i...hp/t127478.html

 

HTH

Tom

[DrumzCT]

Thanks a ton, I forget what search phrases I used but I didn't get that thread.