OsTicket: Reset User Password via SQL: Difference between revisions
From wiki.jacobjohns.com
jwiki>jjohns Created |
jwiki>jjohns Added Logo |
||
| Line 1: | Line 1: | ||
[[File:OsTicket Logo.png|border|center|thumb]] | |||
# Connect to the osTicket database. | # Connect to the osTicket database. | ||
# Show databases. | # Show databases. | ||
Revision as of 06:51, 21 January 2023
- Connect to the osTicket database.
- Show databases.
SHOW databases;
- Use the osTicket database.
USE osticket_database;
- Show tables and look for _staff
SHOW tables;
- Change the password for the desired user.
update _staff set passwd=MD5('NEW_PASSWORD') Where username='USERNAME';
- Test the logon at the user interface.
