MySQL in a Nutshell, 2nd Edition

Name

OLD_PASSWORD()

Synopsis

OLD_PASSWORD(string)

This function encrypts a given string based on the password encryption method used prior to version 4.1 of MySQL. The result cannot be decrypted. Here is an example:

UPDATE teachers
SET pwd = OLD_PASSWORD('test')
WHERE teacher_id = '730522';