OsTicket: Reset User Password via SQL: Difference between revisions
From wiki.jacobjohns.com
jwiki>jjohns Added Logo |
m 5 revisions imported |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
[[File:OsTicket Logo.png | {{DISPLAYTITLE:osTicket: Reset User Password via SQL}} | ||
# Connect to the osTicket database. | [[File:OsTicket Logo.png|center|frameless]] | ||
<hr /><br /> | |||
# Connect to the osTicket database on the osTicket host. | |||
#* <code>sudo mysql</code> | |||
# Show databases. | # Show databases. | ||
#* <code>SHOW databases;</code> | #* <code>SHOW databases;</code> | ||
# Use the osTicket database. | # Use the osTicket database. | ||
#* <code>USE osticket_database;</code> | #* <code>USE osticket_database;</code> | ||
# Show tables and look for _staff | # Show tables and look for _staff. | ||
#* <code>SHOW tables;</code> | #* <code>SHOW tables;</code> | ||
# Change the password for the desired user. | # Change the password for the desired user. | ||
#* <code>update _staff set passwd=MD5('NEW_PASSWORD') Where username='USERNAME';</code> | #* <code>update _staff set passwd=MD5('NEW_PASSWORD') Where username='USERNAME';</code> | ||
# Test the logon at the user interface. | # Test the logon at the user interface. | ||
{{DEFAULTSORT:osTicket:_Reset_User_Password_via_SQL}} | |||
Latest revision as of 16:06, 27 July 2024
- Connect to the osTicket database on the osTicket host.
sudo mysql
- 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.
