MySQL PASSWORD() function
PASSWORD() function
MySQL password() returns a binary string from a plain text password.
The function returns NULL if the string supplied as the argument was NULL.
MySQL server uses this function to encrypt MySQL passwords for storage in the Password column of the user grant table.
Syntax:
PASSWORD(string);
Argument:
Name | Description |
---|---|
string | A string which is to be encrypted using PASSWORD function. |
Syntax Diagram:
MySQL Version: 5.6
Example:
Code:
SELECT PASSWORD('w3resource');
Explanation:
The above MySQL statement encrypts the plain text string w3resource and returns a binary string *EE0804DDC2CC3E85A47191ECCCBA29B775DFFA77.
Sample Output:
mysql> SELECT PASSWORD('w3resource'); +-------------------------------------------+ | PASSWORD('w3resource') | +-------------------------------------------+ | *EE0804DDC2CC3E85A47191ECCCBA29B775DFFA77 | +-------------------------------------------+ 1 row in set (0.00 sec)
Previous: OLD_PASSWORD()
Next: SHA1()
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework