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';
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.