Hello I am looking for a way to produce the same result as with MySQL's PASSWORD function in Java. There are a Implementation of MySQL’s PASSWORD() Function in Java code?
For example:
Password: 123 in MySQL PASSWORD ('123 ') -> *23AE809DDACAF96AF0FD78ED04B6A265E05AA257
I hope you can help me
According to the answer pointed to by @ypercube, MySQL PASSWORD() is just sha1, applied twice.
Using Apache Commons Codec:
public static String MySQLPassword(String plainText) throws UnsupportedEncodingException {
byte[] utf8 = plainText.getBytes("UTF-8");
return "*" + DigestUtils.shaHex(DigestUtils.sha(utf8)).toUpperCase();
}
EDIT: tested, added throws clause, uppercased and a prefix "*".
Working code (to replace shaHex() that was not working):
public static String MySQLPassword(String plainText)
throws UnsupportedEncodingException
{
byte[] utf8 = plainText.getBytes("UTF-8");
byte[] test = DigestUtils.sha(DigestUtils.sha(utf8));
return "*" + convertToHex(test).toUpperCase();
}
*.
sha instead of shaHex, and wrap it with your own function the converts byte[] to a hex String.
sha() twice?Updated itsadok's answer a bit.
public static String MySQLPassword(String plainText) throws UnsupportedEncodingException {
byte[] utf8 = plainText.getBytes("UTF-8");
return "*" + DigestUtils.sha1Hex(DigestUtils.sha1(utf8)).toUpperCase();
}
Here is an example where MessageDigest used, plus converting to HEX string. So, just use it.
http://www.anyexample.com/programming/java/java_simple_class_to_compute_md5_hash.xml
This question is almost the same - replace "Java" with ".NET or MS-SQL-Server" :
simulating-mysqls-password-encryption-using-net-or-ms-sql
It will give you an idea of how to convert MySQL PASSWORD() function into Java.
Please note that PASSWORD() purpose is for MySQL internal use and other, more secure methods should be used for hashing and authentication in application code. Unless you are limited somehow to use this one.
