New Installation - Database import problem

[jennyvu]

I installed Apache2, php4, and MySQL4.1.

I downloaded osCommerce and tried to install, but got stuck at install step 2.
After provided all information: Database server, Username, Password, Database name, etc.
The next page showed:
----
A test connection made to the database was NOT successful.

The error message returned is:

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


Any one has faced this problem and know how to solve it, please help me out.

[developer_x]

Let me know what you have typed in the field for Database server name. If you are installing oscommerce on localhost try this as database server name:

localhost

I think you should not write http:// before the name of database server.

[jennyvu]

Yes, I installed oscommerce on localhost.

I filled as following:
Database Server: localhost
Username: root
Password: (mypassword)
...

Do you think I should down grade the version of Apache (I installed Apache 2.0).

[Arpit]

this has nothing to do with apache, its a mysql version error, before 4.1 they used to have hashes 16 bytes in legth but in later versions it was changed to 41 (sha) and so now if the client and the server have different versions, the hashes would not match, and hence the error,

http://dev.mysql.com/doc/mysql/en/Password_hashing.html

[developer_x]

But Arpit he has installed oscommerce on localhost. Hence, IMHO his problem is not due to different versions of mysql at server and localhost.

[Arpit]

yea so its the mismatch between the php library (aka client) for mysql and the mysql database(aka server)

[jenny]

Had the same problem and spent a day completley re checking my configuration for MySql. In MySqlAdmin you can look to see if the database exists. In the end I discovered that the database set up was causing the problem. So using MySQL I changed to root password for mySQL - logged in - and then checked out the database to ensure that the passwords and user was correct. These steps would also check that your SQL server is working.

Hope this helps

[jennyvu]

Thanks for your message, Jenny.

I think that nothing wrong with my mysql server setup. After installed, I used root password to log in to see that mysql working fine. So, I guess my problem cause by somethinh else.

[makemethis]

.htaccess file ...maybe you need to change the lines that read
#<IfModule mod_php4.c>
# php_value session.use_trans_sid 0
# php_value register_globals 1
#</IfModule>

to
<IfModule mod_php4.c>
php_value session.use_trans_sid 0
php_value register_globals 1
</IfModule>

[jennyvu]

Hi makemethis,

As you suggested, I tried but it didn't help. Problem is still the same.