Could not connect to server localhost as testuser.Client does not support authenticat

[wombatz]

Hi,

installed sugarcrm already several times before, but today on windows server 2003 and i recieved the following error message right after finishing the installation.
Step 7:
database user and password.... ...done
Could not connect to server localhost as testuser. Client does not support authentication protocol requested by server; consider upgrading MySQL client!

Can anybody help me?

[mycrmspacegunnar]

Hi,

MySQL support two types of authentication.
Most PHP versions that are available for download are only linked
to the old mysql cleint library and because of this only suppor the old MySQL authentication.

There are two options now.

a) change your mysql server to run in backward compatible authentication
add this line to the mysql conf file "my.cnf" under the line
[mysqld]
old_passwords=1

b) get PHP from the mysql.com website. Because of this PHP problems MySQL used to provide
PHP version compiled and linked with current mysql client libraries.

c) You can of couse compile PHP yourself ....


I would propose to use method a)
Unless you are running a public accessable server.
In this case using the new more secure authentication is a very good idea.


Cheers
Gunnar