View source for OsTicket: Reset User Password via SQL

{{DISPLAYTITLE:osTicket: Reset User Password via SQL}}
[[File:OsTicket Logo.png|center|frameless]]
<hr /><br />
# Connect to the osTicket database on the osTicket host.
#* <code>sudo mysql</code>
# Show databases.
#* <code>SHOW databases;</code>
# Use the osTicket database.
#* <code>USE osticket_database;</code>
# Show tables and look for _staff.
#* <code>SHOW tables;</code>
# Change the password for the desired user.
#* <code>update _staff set passwd=MD5('NEW_PASSWORD') Where username='USERNAME';</code>
# Test the logon at the user interface.
{{DEFAULTSORT:osTicket:_Reset_User_Password_via_SQL}}