Changing password for liferay default user 'test@liferay.com'

Question

Trying to change Liferay password for default user using the following procedure as documented in http://blogs.aca-it.be/blogs/-/blogs/recovering-an-admin-password-in-liferay . The steps are as follows:

1. Go to the user_ table in the database. 2. Find the user you want to gain access to. 3. Set the password_ field to some plain text password. 4. Set the passwordEncrypted field to 0. 5. Set the passwordReset field to 1. 6. Restart Liferay Log in.

Based on the above steps , I am executing the following command to change the password.

mysql> update user_ set passwordEncrypted=0, password_='password', passwordReset=1 where userId=10196;

After executing the above command , I started liferay and tried to login with the default user 'test@liferay.com' using the new password , but the authentication is still failing.

Kindly suggest .

score 9 · Accepted Answer · answered Aug 12 '14 at 14:55

9

Change password to 'test' using sql:

UPDATE User_ SET password_='qUqP5cyxm6YcTAhz05Hph5gvu9M=' WHERE emailAddress='test@liferay.com';

answered Aug 12 '14 at 14:55

Prime

1,165
6
6

Can you please add how you converted `test` to encrypted text. – Zama Ques Aug 13 '14 at 07:08
I didnt do it myself.I found it at blog long time ago. – Prime Aug 13 '14 at 10:35

score 7 · Answer 2 · answered Oct 24 '16 at 22:24

Just leaving an update for liferay 7 (as I landed here when searching a solution)

UPDATE
    User_
SET
    password_ = 'PASSWORD_IN_CLEAR_TEXT',
    passwordEncrypted = 0,
    passwordReset = 1
WHERE
    userId = USER_ID
;

From: https://www.e-systems.tech/blog/-/blogs/liferay-7-how-to-reset-user-password-in-database

Changing password for liferay default user 'test@liferay.com'

2 Answers2