From: Date: January 15 2004 11:50pm
Subject: Error: Client does not support authentication protocol requested by
List-Archive: http://lists.mysql.com/win32/13142
Message-Id: <00d801c3dbb9$ebb44b00$3f03a8c0@josuew2k>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00D5_01C3DB87.A05D8FE0"

------=_NextPart_000_00D5_01C3DB87.A05D8FE0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks for All

The answer of my problem it is.

the function OLD_PASSWORD()  for server 4.1 and higher...

http://www.mysql.com/doc/en/Password_hashing.html

(Thanks special for Jamie Murray and William Curry)

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Scenario 2) Long Password column; server not started with =
--old-passwords option=20

  a.. Short or long hashes can be stored in the Password column.=20
  b.. 4.1 clients can authenticate for accounts that have short or long =
hashes.=20
  c.. Pre-4.1 clients can authenticate only for accounts that have short =
hashes.=20
  d.. For connected clients, password hash-generating operations =
involving PASSWORD(), GRANT, or SET PASSWORD use long hashes =
exclusively. Any change to an account's password results in that account =
having a long password hash.=20
  e.. OLD_PASSWORD() may be used to explicitly generate a short hash. =
For example, to assign an account a short password, use UPDATE as =
follows:=20
mysql> UPDATE user SET Password =3D OLD_PASSWORD('mypass')
    -> WHERE Host =3D 'some_host' AND User =3D 'some_user';
mysql> FLUSH PRIVILEGES;
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


Gracias

att. joshua
Zapopan, Jalisco, M=E9xico
www.josue.dnsalias.com

..(\(\
  (=3D';')=20
  (,,('')('')
------=_NextPart_000_00D5_01C3DB87.A05D8FE0--