In the scenario where an admin forgets their password or is locked out and needs to change the password it can be done through phpMyAdmin.
Open phpMyAdmin through Cpanel or other methods depending on the hosting setup and find the WordPress database. Click on the WordPress database and a table called mainusers should be found. Click on that table name to open it and see the list of users in the table.
Click Edit next to the user that needs the password changed and it should look similar to the image below.
On this page choose MD5 from the Function dropdown menu and enter in the new password into the Value text field. At the bottom of the page click Go.
Message should be displayed in phpMyAdmin stating the row was updated. The user account should be able to login with the new password.