reset liferay IDE admin password

[Yu Zhang, modificado hace 10 años.]

Hi,
just installed the liferay IDE on Eclipse, everything works fine until I forgot the password I have just set.
Tried the 'forgot password' link, but could not receive email due to smtp host is set to locahost, tried the ROOT.xml, but the smtp setting is not there.

Could anyone tell me:
1. alternative way to reset the password, (in database, or any file)?
2. how to change the smtp host settings?

Many thanks

Yu

[Patrick Wolf, modificado hace 10 años.]

Hi,

Do you use the embedded HSQL database or another database?

Let's assume you use MySQL or another database, you may try to run this query:

UPDATE User_ SET password_='qUqP5cyxm6YcTAhz05Hph5gvu9M=' WHERE emailAddress='admin_name@domain_name.com';

After that, use "test" as password. This should work.
If you installed Liferay and did not explicitly specify a data source name, HSQL is running by default.

Best regards,
Patrick Wolf