Reset Kayako Admin password from Mysql Database

Kayako is a leading helpdesk application, which has found global acceptance. Since Kayako follows a strict account lockout policy, I have seen many System Admins looking for a quick way to reset password under such circumstances when the helpdesk front end is unaccessible due to a forgotten or a lost password. Here, we discuss a quick way to reset the admin password from the database backend.

Use the following MySQL query to fetch a list of your staff users:
select title,fullname,username from swstaff sw join swstaffgroup sg on (sw.staffgroupid=sg.staffgroupid);

Identify the username of the staff user you will reset the password of, then tailor this second MySQL query:
update swstaff set staffpassword=sha1('qwerty012!@#') where username='admin';

This will reset the password of the 'admin' staff user to 'qwerty012!@#'.