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

MySQL TUTORIALS » Encryption Compression Functions » PASSWORD »

PASSWORD(str) calculates and returns a password string from the plaintext password str and returns a binary string.

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


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

mysql>