MySQL Error: Client does not support authentication protocol requested by server

[mrjason]

I have php 4.3.6 installed. mysql 4.1.1.

I'm attempting to run the install.php script. When i fill in the initial admin and db login requirements, i get the following error at the top of the same page:

Could not create a mySQL connection, please check the SQL values entered

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

I'm not sure what i've done wrong here. I've doubly checked i correctly created and granted usage priveleges on my database.

If some of you are familiar with PHPbb.. i recently installed that as well and have no such problems with the mysql cnnections or quieres from it.

I know i've correctly filled out my database information..

Host : localhost
DB : coppermine
User : copper
pass : ..

Does coppermine require ssl or something?

I have tried the install.php on both 1.3.0 (Stable) and 1.3.1. Should i use 1.2?

I am not upgrading, this is a fresh install, my first time installing coppermine.

[kegobeer]

This is discussed on the MySQL site:
http://mysql.megalink.com/doc/mysql/en/Old_client.html

[mrjason]

fixed. according to http://mysql.megalink.com/doc/mysql/en/Old_client.html the php client i am using use an old password hasing scheme.

this did not affect my phpbb because i stupidly left the phpbb account without a password (which has now been fixed).

the remedy is this..

mysql> SET PASSWORD FOR
    -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

[Joachim Müller]

thanks for reporting back and resolving this issue (I wish everybody did).

GauGau

[mrt]

Did this issue ever get resolved?

I am installing 1.3.2 on a server running php 4.6 and mysql 4.1.1

It appears that mysql uses a new password scheme that is not yet supported by CPG?  If I alter the password in the database with the old password scheme I can get it to work,  but by default using the new password scheme,  it will not and complains that mysql is out of date.

Any thoughts on this or suggested changes to be made to the CPG script?

Thanks Matt

[Casper]

Yes, it was resolved 2 posts above yours, and acknowledged in the next one 

[mrt]

I found a better solution for those that are not running PHP5

For those who are running PHP 4.X and  MySQL 4.1 or newer you can add this line to your my.cnf file to force old password authentication to function on the newer mysql database server.

set-variable = old-passwords

Hope you find this helpful.

Thanks Matt

[cpthk]

did someone try to update the binary library(*.dll) without reset to pre-4.1 version password style?