Re: Lighten up, man!

[Lenz Grimmer]

Hi,

anthony katgert wrote:

> Perhaps I should have picked my words more
> carefully.. but what did you expect. ?

You could have started with posting a more detailed description of the problem you are facing, like you did now.

> 1251 Client does not support authentication protocol requested by
> server; consider upgrading MySQL client
>
> Dreamweaver MX 2004 cannot connect with the MySQL
> server.. on my Windows XP Pro (SP2 installed)
> workstation.

Dreamweaver MX seems to be linked against an older version of the MySQL client library (probably version 3.23 or 4.0). Starting with MySQL 4.1, the MySQL server uses a more secure authentication protocol, which unfortunately is not compatible with older versions of the client library. Hence the error message you see.

The recommended solution is of course to use a newer version of the client library. In cases like yours, where the client lib is part of a commercial application (and you can't simply rebuild it against newer client libs), you can work around this by creating a special MySQL user account that uses the old password scheme or by forcing the MySQL server to speak the old authentification protocol exclusively. This can be accomplished by using the "old_passwords" configuration option, which needs to be added to the [mysqld] section of my.ini.

See http://dev.mysql.com/doc/refman/4.1/en/old-client.html for more details on this subject.

Bye,
LenZ

Lenz Grimmer - MySQL Community Relations Manager - http://de.sun.com/
Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten, DE
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels
Vorsitz d. Aufsichtsrates: Martin Haering AG Muenchen: HRB161028