How to reset the password?

[ianarman1]

What is the procedure to reset broken admin passwords?

[ghost]

There doesn't seem to be an official way to do this. You can instead do it manually, assuming you have access to the back-end database.

Note: Passwords are 'hashed' using MD5, you can use an online generator or md5sum to get your desired hash.

ubuntu@ubuntu:~$ echo -n "testing" | md5sum
ae2b1fca515949e5d54fb22b8ed95575 -

mysql> DESCRIBE users;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | int         | NO   | PRI | NULL    | auto_increment |
| name     | varchar(50) | NO   |     | NULL    |                |
| email    | varchar(35) | NO   |     | NULL    |                |
| mobile   | varchar(15) | NO   |     | NULL    |                |
| username | varchar(50) | NO   |     | NULL    |                |
| password | varchar(50) | NO   |     | NULL    |                |
| type     | int         | NO   |     | NULL    |                |
| status   | int         | NO   |     | NULL    |                |
| created  | int         | NO   |     | NULL    |                |
| updated  | int         | NO   |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

mysql> SELECT id, type, username, password FROM users;
+----+------+------------+----------------------------------+
| id | type | username   | password                         |
+----+------+------------+----------------------------------+
|  1 |   80 | admin.demo | fe01ce2a7fbac8fafaed7c982a04e229 |
|  2 |   10 | user.demo  | fe01ce2a7fbac8fafaed7c982a04e229 |
|  3 |   60 | agent.demo | fe01ce2a7fbac8fafaed7c982a04e229 |
+----+------+------------+----------------------------------+
3 rows in set (0.00 sec)

mysql> UPDATE users SET password = "ae2b1fca515949e5d54fb22b8ed95575" WHERE id = 1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT id, type, username, password FROM users;
+----+------+------------+----------------------------------+
| id | type | username   | password                         |
+----+------+------------+----------------------------------+
|  1 |   80 | admin.demo | ae2b1fca515949e5d54fb22b8ed95575 |
|  2 |   10 | user.demo  | fe01ce2a7fbac8fafaed7c982a04e229 |
|  3 |   60 | agent.demo | fe01ce2a7fbac8fafaed7c982a04e229 |
+----+------+------------+----------------------------------+
3 rows in set (0.00 sec)

[eksha]

@CRFSlick thank you for the detailed explanation. @ianarman1 hope this works for you for now.

I will be creating a feature request issue and closing this one.