How to reset the admin password for Observium

How can i reset the password for the user admin with MySQL or a Observium script.

MariaDB [observium]> select * from users;
+---------+----------+------------------------------------+----------+-------+-------+-------+-------------------+--------------+
| user_id | username | password                           | realname | email | descr | level | can_modify_passwd | user_options |
+---------+----------+------------------------------------+----------+-------+-------+-------+-------------------+--------------+
|       1 | admin    | $1$abcdefgh$jklmnopqrstuvwxyzabcd. |          |       |       |    10 |                 1 | NULL         |
+---------+----------+------------------------------------+----------+-------+-------+-------+-------------------+--------------+
1 row in set (0.00 sec)

Look like it MD5 (1) hash with salt (abcdefgh).

openssl passwd -1 build new hash from plain password

You can use it to update users table.

You can try build Mysql-only solution based on https://stackoverflow.com/questions/5903702/md5-and-salt-in-mysql

But salt must be cryptographic quality random for secyrity.

UPD.

Blackbox Hacking solution. Copy password field from other user with known password, event from different instance of observium. It work 99%