OLD_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 using the old implementation of PASSWORD() (pre-MySQL 4.1).
USAGE
OLD_PASSWORD(string)
Argument Name | Description |
|---|---|
| The string to transform |
DETAILS
OLD_PASSWORD() is an encryption function that returns an encrypted string using the old implementation of PASSWORD() (pre-MySQL 4.1).
An encrypted string value is 16-bytes in length.
A NULL is returned if the argument is NULL.
EXAMPLES
SELECT OLD_PASSWORD('MariaDB42!');
+----------------------------+
| OLD_PASSWORD('MariaDB42!') |
+----------------------------+
| 0732aa4d6a3a72a8 |
+----------------------------+
SELECT PASSWORD('MariaDB42!');
+-------------------------------------------+
| PASSWORD('MariaDB42!') |
+-------------------------------------------+
| *07A469684341365CDFBADCAEF5FCD6B57F881A9A |
+-------------------------------------------+