The Solution

Go into PhpMyAdmin. The URL should be http://localhost/phpmyadmin, but it might vary depending on configurations. Look for the database name on the left sidebar. In our case it’s called “wordpress“.

Click “wordpress“ to see its tables. Look for *_users, in our case it’s called wp1_users. Click it and you’ll notice a page change on the right frame. user_login column shows you all usernames you currently have. If you are looking for usernames, your problem is solved. But if you are looking to recover lost password, there is one more thing you’ll need to do.

Click on the pen icon to edit the data for the specific user. Look for “user_pass” field. Select "MD5" for the Function dropdown, and change it’s value to a new password, in our case the new password is call “admin“. Click GO once you are done.

That’s it! You’ve just changed the password for username admin to “admin“.