OsTicket: Reset User Password via SQL

1. Connect to the osTicket database on the osTicket host.
   • sudo mysql
2. Show databases.
   • SHOW databases;
3. Use the osTicket database.
   • USE osticket_database;
4. Show tables and look for _staff.
   • SHOW tables;
5. Change the password for the desired user.
   • update _staff set passwd=MD5('NEW_PASSWORD') Where username='USERNAME';
6. Test the logon at the user interface.