How to reset admin password with phpmyadmin?

Question

DLE

Hello.
There is one site that runs on the dle system.
All hosting passwords are there, I was able to log into phpmyadmin.
And I was able to find the table where the administrator password is stored.

now tried to just immediately change the password from here. I inserted the password in the form of md5, nothing happens.
How can the problem be solved. The password was last written in 2007. And the customer does not remember anything.

Answer 1

The option is as follows:
1. register a new user with the desired password
2. go to the database
3. find a new user
4. Copy the password hash
5. Paste it to the desired user (you admin or whatever you are in the database)
6. Everything is ready
PS: hash The password in the database is made so that it cannot be decrypted or changed. Other methods will either not help or be more time consuming than the one I suggested.

Answer 2

There is a double md5.
md5(md5("pass"));