Back to General and Gameplay Programming

mysql - PASSWORD()

General and Gameplay Programming Programming

Started by Leadorn March 31, 2003 12:43 PM

1 comment, last by Leadorn 21 years ago

Leadorn

100

Author

March 31, 2003 12:43 PM

Hi There is an encryption named password in mysql, one-way encryption. Does anyone know how it works? Cause I need one function to encrypt with, so that I can compare incoming password with password from database. Is there any vulnerabilities with password(), should I use MD5 instead?

krez

443

March 31, 2003 01:12 PM

from the mySQL documentation:

quote:PASSWORD() encryption is non-reversible. PASSWORD() does not perform password encryption in the same way that Unix passwords are encrypted. See ENCRYPT(). The PASSWORD() function is used by the authentication system in MySQL Server, you should not use it in your own applications. For that purpose, use MD5() or SHA1() instead.

--- krez ([email="krez_AT_optonline_DOT_net"]krez_AT_optonline_DOT_net[/email])

Leadorn

100

Author

March 31, 2003 01:23 PM

Oki