Follow the below steps to change Liferay admin password using MySQL:
- Open MySQL workbench.
- navigate to your schema.
- run the below query to change password to ‘test’ for your admin ([email protected]) using SQL.
UPDATE User_ SET password_='qUqP5cyxm6YcTAhz05Hph5gvu9M=' WHERE emailAddress='[email protected]';