PASSWORD()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns an encrypted string from a plaintext password.
USAGE
PASSWORD(string)
Argument Name | Description |
|---|---|
| The string to encrypt |
DETAILS
PASSWORD() is an encryption function that returns an encrypted string from a password string.
By default, the return value is an encrypted hash that is 41-bytes in length and has a first character that is '*'. An authentication plugin can be used to generate other hash values.
The return value is an empty string when the argument is NULL.
EXAMPLES
SELECT PASSWORD('MariaDB42!');
+-------------------------------------------+
| PASSWORD('MariaDB42!') |
+-------------------------------------------+
| *07A469684341365CDFBADCAEF5FCD6B57F881A9A |
+-------------------------------------------+