Manually recover Liferay admin password

I forgot liferay admin password for a brand new production configuration. That is not big deal if the server has accessible SMTP but in my case the hosting provider hadn't enabled it so I knew my only option was to touch the database directly.

Password string "test" after encryption becomes 'qUqP5cyxm6YcTAhz05Hph5gvu9M=' so the below statement will take care of reseting the password to test (Of course in production you must never have the original test@liferay.com user so change that by the real admin email in your system)

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