Login after install doesn't work

[hknoerrer]

Hi!
I try to install mantis 1.0.1 on
Apache/2.0.52 (Unix) PHP/4.3.9 -> Client API version 3.23.49
with MySQL 4.1.8-standard


After successful install of mantis i try to login.
i call the index.php an get immediately the message:
"SYSTEM WARNING: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"

in the first line.

There is also a box below with :
"APPLICATION ERROR #400

Database connection failed. Error received from database was #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client"

[hknoerrer]

Sorry!!!

It may be the problem with MySQL oldpassword.

But the funny thing is : The install works

[jkohon]

Solution Tested and working:

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

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


More info in link:

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