MySQL Forums
Forum List  »  Install & Repo

Re: Lighten up, man!
Posted by: Lenz Grimmer
Date: March 29, 2006 03:12AM


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 for more details on this subject.


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

Options: ReplyQuote

Written By
December 31, 2005 12:02AM
December 31, 2005 02:28AM
Re: Lighten up, man!
March 29, 2006 03:12AM
March 24, 2007 02:58PM
January 03, 2006 07:48AM
March 16, 2006 10:03AM
November 02, 2005 07:38AM
January 16, 2006 03:46PM
July 24, 2006 07:40AM
March 28, 2006 11:18PM
August 23, 2006 01:21PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.