Recover admin password - Truenas

[AcrimoniousMirth]

Hi,
Set up with username and password and been locked out. Both are correct, I recorded them securely immediately after setup.
Any way to recover and save on having to reinstall and reconfigure everything? Not sure where to start...
Thanks!

[AcrimoniousMirth]

Okay, thanks in the most part to judicial application of Google AntiGravity, I have made good progress. Here's the readout of what I did:

$ mariadb -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 44
Server version: 12.2.2-MariaDB-ubu2404 mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| booklore           |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.002 sec)

MariaDB [(none)]> USE booklore;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [booklore]> SHOW TABLES;
+--------------------------------+
| Tables_in_booklore             |
+--------------------------------+
| annotations                    |
| app_migration                  |
| app_settings                   |
| author                         |
| book                           |
| book_award                     |
| book_file                      |
| book_marks                     |
| book_metadata                  |
| book_metadata_author_mapping   |
| book_metadata_category_mapping |
| book_metadata_mood_mapping     |
| book_metadata_tag_mapping      |
| book_notes                     |
| book_notes_v2                  |
| book_shelf_mapping             |
| bookdrop_file                  |
| category                       |
| cbx_viewer_preference          |
| custom_font                    |
| ebook_viewer_preference        |
| email_provider                 |
| email_provider_v2              |
| email_recipient                |
| email_recipient_v2             |
| epub_viewer_preference         |
| flyway_schema_history          |
| jwt_secret                     |
| kobo_library_snapshot          |
| kobo_library_snapshot_book     |
| kobo_reading_state             |
| kobo_removed_books_tracking    |
| kobo_user_settings             |
| koreader_user                  |
| library                        |
| library_path                   |
| magic_shelf                    |
| metadata_fetch_jobs            |
| metadata_fetch_proposals       |
| mood                           |
| new_pdf_viewer_preference      |
| opds_user                      |
| opds_user_v2                   |
| pdf_viewer_preference          |
| public_book_review             |
| reading_sessions               |
| refresh_token                  |
| shelf                          |
| tag                            |
| task_cron_configuration        |
| tasks                          |
| user_book_progress             |
| user_email_provider_preference |
| user_library_mapping           |
| user_permissions               |
| user_settings                  |
| users                          |
+--------------------------------+
57 rows in set (0.000 sec)

MariaDB [booklore]> SELECT id, username, email FROM users;
+----+-----------------+-------------------------------+
| id | username        | email                         |
+----+-----------------+-------------------------------+
|  1 |MY_USERNAME | MY_EMAIL@MAIL.COM                   |
+----+-----------------+-------------------------------+
1 row in set (0.000 sec)

MariaDB [booklore]> DESCRIBE users;
+---------------------+--------------+------+-----+---------------------+----------------+
| Field               | Type         | Null | Key | Default             | Extra          |
+---------------------+--------------+------+-----+---------------------+----------------+
| id                  | bigint(20)   | NO   | PRI | NULL                | auto_increment |
| username            | varchar(255) | NO   | UNI | NULL                |                |
| password_hash       | varchar(255) | NO   |     | NULL                |                |
| is_default_password | tinyint(1)   | NO   |     | 1                   |                |
| name                | varchar(255) | NO   |     | NULL                |                |
| email               | varchar(255) | YES  | UNI | NULL                |                |
| book_preferences    | text         | YES  |     | NULL                |                |
| created_at          | timestamp    | NO   |     | current_timestamp() |                |
| provisioning_method | varchar(50)  | YES  |     | NULL                |                |
+---------------------+--------------+------+-----+---------------------+----------------+
9 rows in set (0.002 sec)

MariaDB [booklore]> UPDATE users SET password_hash = '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi' WHERE username = 'MY_USERNAME';
Query OK, 1 row affected (0.003 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [booklore]> 

Password should now be "password".

[beedaddy]

Just for the record, what kind of hash is it and how did you create it?