OsTicket

How to rest lost admin password using mysql terminal

First you need acces to VPS

Then login to mysql using

mysql -u root -p

then access your osticket database !

mysql> show databases;
+------------------------+
| Database               |
+------------------------+
| information_schema     |    |
| mysql                  |
| osticket.techridez.com |
| page.techridez.com     |
| performance_schema     |   |
| phpmyadmin             | |
| sys                    |
| vanilla_db             |
+------------------------+
8 rows in set (0.02 sec)

mysql> use osticket.techridez.com

now you have to change database to your's i am using osticket.techridez.com

then use

UPDATE `ost_staff` SET `passwd` = MD5( 'password' ) WHERE `staff_id`='1';

Where ost_staff is your table

password = you need to change with new password

staff_id=1 = 1 use used as admin

UPDATE `ost_staff` SET `passwd` = MD5( 'password' ) WHERE `staff_id`='1';