PS, the document I send you also mentions:
To change the password but create a short hash, use the OLD_PASSWORD()
function instead:
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
ht
>Thanks. So how does one use the password function in MySQL 5?
Most probably just the same, but your MySQL 4 password hashes are
incompatible
with MySQL 5 password hashes.
A search on "password" in the MySQL docs returns quite some stuff, see:
http://dev.mysql.com/doc/refman/5.0/en/password-hash
