Re: 1251 client does not support... Dreamweaver/MySQL db connection
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