Blog

In this guide, we will explain how to use the MySQL PASSWORD function with syntax and examples.

Description

The MySQL PASSWORD function is used by the authentication system in MySQL to generate a hashed password from a plaintext password string using more powerful hashing techniques that were introduced in MySQL 4.1. To use older hashing techniques, use the OLD_PASSWORD function.

Syntax

The syntax for the PASSWORD function is:

PASSWORD( string )

Parameters or Arguments

string

A plaintext password string that is the source to create an encrypted/hashed password in MySQL.

Note

• The PASSWORD function will return NULL, if the string is NULL.
• The PASSWORD function performs encryption one-way.
• The PASSWORD function is used by the authentication system in MySQL to store passwords.
• Do not use th PASSWORD function in your own application, use the MD5 or SHA1 functions instead.
• See also the ENCRYPT function.

Applies To

The PASSWORD function can be used in the following versions :

• MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1

Example

Let’s look at some PASSWORD function examples and explore how to use the PASSWORD function.

For example:

mysql> SELECT PASSWORD('abc');
Result: '*0D3CED9BEC10A777AEC23CCC353A8C08A633045E'

mysql> SELECT PASSWORD('password');
Result: '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19'

mysql> SELECT PASSWORD('adglob');
Result: '*0886644237EED5C45BE221093802B5AB0C06D2D0'

mysql> SELECT PASSWORD(NULL);
Result: NULL

Learn More : Click Here