Syntax
------ 
ENCRYPT(str[,salt])
 
Description
----------- 
Encrypts a string using the Unix crypt() system call,
returning an encrypted binary string. The salt argument
should be a string with at least two characters or the
returned result will be NULL. If no salt argument is given,
a random value of sufficient length is used.
 
It is not recommended to use ENCRYPT() with utf16, utf32 or
ucs2 multi-byte character sets because the crypt() system
call expects a string terminated with a zero byte.
 
Note that the underlying crypt() system call may have some
limitations, such as ignoring all but the first eight
characters.
 
If the have_crypt system variable is set to NO (because the
crypt() system call is not available), the ENCRYPT function
will always return NULL.
 
Examples
-------- 
SELECT ENCRYPT('encrypt me');
+-----------------------+
| ENCRYPT('encrypt me') |
+-----------------------+
| 4I5BsEx0lqTDk |
+-----------------------+
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/encrypt/