	©	SQL :: Manager
				Home	Program Information	Technical details	Free download	Donate for a cup of coffee

The PASSWORD SQL Function in MySQL and MariaDB - Generate password hash

PASSWORD	Syntax:	PASSWORD(String)
	Return value:	CHAR
	Function type:	Encryption & Compression

Function Description

The PASSWORD() function returns a hashed password string computed from "String".

This function is the SQL interface to encrypt passwords for storage in the authorization table.

The return value is a string in the connection's character set.

Numeric values are interpreted as a character string.

If "String" contains no characters, the function returns an empty string.

If the value of "String" is NULL, the PASSWORD() function returns NULL.

SQL Examples for the PASSWORD function


SELECT password('Test');
SELECT password('New Password');
SELECT password(54321);

SELECT password(' ');
SELECT password('');
SELECT password(null);

password('Test')
varchar(41) BINARY
*AF31C6CBDECD88726D0A9B3798C71EF41F1624D5

password('New Password')
varchar(41) BINARY
*12B8D04CBF632C1876A0526B53668AE6DB63B08B

password(54321)
varchar(41) BINARY
*273162E1A674997C0F6481B0BB677E62B5065A00

password(' ')
varchar(41) BINARY
*1A256E4E2FE95B8BF7349C168991EA8035D1359B

password('')
varchar(41) BINARY

password(null)
varchar(41) BINARY
NULL

The examples were created with the MyWAY SQL manager: Download

How to use the PASSWORD() function in MySQL and MariaDB databases

In MySQL and MariaDB the PASSWORD() function is used to hash a password using the native password hashing algorithm of the database by taking a string (password) as input and returning the hashed value as an encoded string.

The native password hashing algorithm used by MySQL and MariaDB may vary depending on the version and configuration of the database, but there should be a better one provide security than the older password hashing algorithms such as the OLD_PASSWORD() or MD5() function, as these algorithms provide stronger protection against brute force attacks and password cracking. The function is rather unsuitable for general hashing purposes.

Further MySQL und MariaDB SQL Encryption & Compression

AES_DECRYPT	AES_DECRYPT(String, Key)
	More about AES_DECRYPT Function

AES_ENCRYPT	AES_ENCRYPT(String, Key)
	More about AES_ENCRYPT Function

COMPRESS	COMPRESS(String)
	More about COMPRESS Function

DECODE	DECODE(Binary string, Password)
	More about DECODE Function

DES_DECRYPT	DES_DECRYPT(Binary string [, Key])
	More about DES_DECRYPT Function

DES_ENCRYPT	DES_ENCRYPT(String [, Key])
	More about DES_ENCRYPT Function

ENCODE	ENCODE(String, Password)
	More about ENCODE Function

ENCRYPT	ENCRYPT(String [, Salt])
	More about ENCRYPT Function

FROM_BASE64	FROM_BASE64(String)
	More about FROM_BASE64 Function

MD5	MD5(String)
	More about MD5 Function

OLD_PASSWORD	OLD_PASSWORD(String)
	More about OLD_PASSWORD Function

RANDOM_BYTES	RANDOM_BYTES(Length)
	More about RANDOM_BYTES Function

SHA	SHA(String)
	More about SHA Function

SHA1	SHA1(String)
	More about SHA1 Function

SHA2	SHA2(String, Length)
	More about SHA2 Function

TO_BASE64	TO_BASE64(String)
	More about TO_BASE64 Function

UNCOMPRESS	UNCOMPRESS(Binary string)
	More about UNCOMPRESS Function

Numeric functions	String functions	Regular Expressions	Date and Time functions
Comparison functions	Encryption & Compression	Conversion functions	NULL functions
Aggregate functions	Window functions	JSON functions	Geometric functions
Sequence functions	Information functions	Dynamic Columns	Miscellaneous functions

More information about the PASSWORD SQL function: mysql.com and mariadb.com

Updated: 2023-09-24

2020-2024 Heino Cunze-Fischer