MySQL in a Nutshell, 2nd Edition

Name

PASSWORD()

Synopsis

PASSWORD(string)

This function encrypts a password given as an argument. The result cannot be decrypted. This function is used for encrypting data in the password column of the user table in the mysql database. Here is an example:

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