Liferay: how to reset user password in database (use in dev dev only!)

Warnings

Don’t do this in production environments! Following this procedure will store passwords in clear text in your database!

It can be useful if you want to reset default admin user password, or somebody’s password in a test environment.

Procedure

Find the user id of the user you want to reset his password. Pretty easy to find in database (hint: table User_ ;) )

• Stop Liferay
• Execute this query

UPDATE 
	User_
SET 
	password_ = '<PASSWORD_IN_CLEAR_TEXT>',
    passwordEncrypted = 0
WHERE 
	userId = <USER_ID>
;

• Start Liferay
• Login with new password! It’s working fine :)

Did I say that you should not do it in production environments? ;)