Hi, How would you do that with MySQL in the first place? From what I understand, PASSWORD() does one-way encryption:
http://dev.mysql.com/doc/refman/5.6/en/encryption-functions.html#function_password You should compare password hashes, not plain text passwords. I.e., if USERS.PASSWORD is the column holding the encrypted password, do something along these lines: SELECT 1 FROM USERS WHERE NAME = ... AND PASSWORD = PASSWORD('something') Cheers Lukas 2012/6/18 <[email protected]>: > I am trying to figure out how to use jooq functions to do that. > > I am stuck in getting the plain text password encoded using the > password('something') in mysql
