List:General Discussion« Previous MessageNext Message »
From:Chris Wilson Date:January 29 2002 4:44pm
Subject:Re: MySQL PASSWORD function
View as plain text  
I think mysql uses the system crypt() function. This is, no-doubt, available
through some well hidden Java class. Just do "man crypt" to learn about
crypt().

Chris

On Tue, 29 Jan 2002 10:59:55 -0500
John Kemp <jkemp@stripped> wrote:

> Hi all,
> 
> I can't find a description of the algorithm used in the mySQL PASSWROD 
> function. I understand it's a hashing algorithm of some kind, but I 
> don't know which algorithm (and I suspect it's *not* MD5.)
> 
> Can anyone tell me what algorithm PASSWORD uses? The reason I ask is 
> that we're trying to implement role-based security using our existing 
> MySQL table of users, accessed via Java Servlet auth functions, which 
> can read the User table through JDBC. BUT.... they don't know anything 
> about PASSWORD-encrypted passwords, so I need to write something that 
> hashes the password entered in the same way MySQL hashes a password (or 
> abandon the use of servlet auth :-)
> 
> Any clues?
> 
> John Kemp,
> Director, Software Development
> Streetmail Inc.
> http://www.streetmail.com
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread97850@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-chris=lists.wapmx.com@stripped>> Trouble
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php> 
> 


-- 
Chris Wilson <chris@stripped>
http://www.wapmx.com

Thread
MySQL PASSWORD functionJohn Kemp29 Jan
  • Re: MySQL PASSWORD functionDan Nelson29 Jan
  • Re: MySQL PASSWORD functionSinisa Milivojevic29 Jan
  • Re: MySQL PASSWORD functionChris Wilson29 Jan
  • RE: MySQL PASSWORD functionCarsten H. Pedersen29 Jan