It is a simple way to change the password if you can’t reset it through the embedded password recovery procedure.
In the phpMyAdmin or other DB management system, we are looking for a table
*_user
Then we pick Edit in front of the needed to change the user whose password needs to be changed, for example, admin
In expanded fields, we are going to edit the password in the MD5 mode
After editing in the right bottom place, push Go to save these changes.