MySQL Forums
Forum List  »  PHP

Re: 1251 client does not support... Dreamweaver/MySQL db connection
Posted by: Reynier Pérez Mira
Date: November 07, 2005 08:57AM

Graham Hutchinson wrote:
> MySQL 4.1 and up uses an authentication protocol
> based on a password hashing algorithm that is
> incompatible with that used by older clients and
> software such as Dreamweaver MX 2004.
>
> If you upgrade the server to 4.1, attempts to
> connect to it with an older client may fail with
> the following message:
>
> Error: 1251 Client does not support authentication
> protocol requested by server; consider upgrading
> MySQL client.
>
> To solve this problem, you should 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: (enter this code through
> the MySQL command line client-- c:\Program
> Files\MySQL Server 4.1\bin\mysql.exe)
>
> mysql> SET PASSWORD FOR
> -> 'some_user'@'some_host' =
> OLD_PASSWORD('newpwd');
>
> Example:
> username: root
> host: localhost
> password: xxxxxx
>
> mysql> SET PASSWORD FOR
> -> 'root'@'localhost' =
> OLD_PASSWORD('xxxxxx');
>
>
> Hopefully this will solve any of your problems
>
> For a more detailed description of the pre-4.1
> client program and the OLD_PASSWORD() function
> refer to Article:
> http://dev.mysql.com/doc/mysql/en/old-client.html
>
> Graham Hutchinson
> Student
> University of Dayton

Well, I use NuShere PHPEd for build my PHP applications but when I try to connect the NuSPhere DB Client with my MySQL 4.1.12 Server I obtain the same message error. Few months ago I found a possible answer to this. I described below what I'm doing but now not works and I not know why. First I have installed MySQL Administrator. Open and login as root user. Then I go to "Startup variables->Security" and then check "Use Old Passwords". Then I restart my SQL service. But surprise when I try again the same error appear. What´s worng with my method?? I can´t know how to access to MySQL from a command line using user and password.

Cheers

Well I use MySQL Administrator and put this directive

Options: ReplyQuote


Subject
Written By
Posted
Re: 1251 client does not support... Dreamweaver/MySQL db connection
November 07, 2005 08:57AM


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.