This article provides a guide on how to reset the administrator password when you do not have access to the Helpdesk.
- If you are a Kayako On Demand customer, please contact customer support and we will help you regain access to your helpdesk.
- If you have a Download license and have installed Kayako on your own web server, you will need direct access to MySQL in order to reset a password.
To do a password reset, follow the steps below:
- Use the following MySQL query to fetch a list of your staff users:
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:
SET staffpassword = Sha1('asd123!@#')
WHERE username = 'admin';
This second query will reset the password of the 'admin' staff user to 'asd123!@#'.