List:MySQL on Win32« Previous MessageNext Message »
From:Josue Mora Date:January 15 2004 11:50pm
Subject:Error: Client does not support authentication protocol requested by
View as plain text  
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)

================================================================

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

  a.. Short or long hashes can be stored in the Password column. 
  b.. 4.1 clients can authenticate for accounts that have short or long hashes. 
  c.. Pre-4.1 clients can authenticate only for accounts that have short hashes. 
  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. 
  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: 
mysql> UPDATE user SET Password = OLD_PASSWORD('mypass')
    -> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
====================================================================


Gracias

att. joshua
Zapopan, Jalisco, México
www.josue.dnsalias.com

..(\(\
  (=';') 
  (,,('')('')
Thread
Error: Client does not support authentication protocol requested byJosue Mora15 Jan