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 (test@liferay.com) using SQL.
UPDATE User_ SET password_='qUqP5cyxm6YcTAhz05Hph5gvu9M=' WHERE emailAddress='test@liferay.com';