PASSWORD

Declaration

PASSWORD(str)

Description

Encrypts a string. It takes a plaintext string as a parameter and returns the encrypted version of the string.

Example

SELECT PASSWORD('***1***');

The return result is as follows:

+--------------------------------------------+
| PASSWORD('***1***')                        |
+--------------------------------------------+
| *BA10AFC5C8D9F9D1A5704E9C274C1A63EE9CB94B  |
+--------------------------------------------+
1 row in set (0.001 sec), 1 warning