PASSWORD(str) calculates and returns a password string from the plaintext password str and returns a binary string. : PASSWORD « Encryption Compression Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Encryption Compression Functions
  3. PASSWORD

PASSWORD() encryption is one-way, not reversible.

mysql>
mysql> SELECT PASSWORD('badpwd');
+-------------------------------------------+
| PASSWORD('badpwd')                        |
+-------------------------------------------+
| *AAB3E285149C0135D51A520E1940DD3263DC008C |
+-------------------------------------------+
1 row in set (0.00 sec)

mysql>








19.13.PASSWORD
19.13.1.PASSWORD(str) calculates and returns a password string from the plaintext password str and returns a binary string.
19.13.2.Use password function to ENCRYPT first name