lost admin password for osTicket

osTicket is is a widely-used open source support ticket system. It seamlessly integrates inquiries created via email, phone and web-based forms into a simple easy-to-use multi-user web interface.

I use osTicket and sometimes I forget my admin password.
Since there is no automated password receovery for the admin user it is necessary to run a MYSQL query to reset the password.

Here it is

UPDATE `ost_staff` SET `passwd` = MD5( ‘mynewpassword’ ) WHERE `username` = ‘myusername’ LIMIT 1 ;