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 by | Josue Mora | 15 Jan |