Publish: 2014-12-01 | Modify: 2021-01-26
Some friends may forget their usernames or passwords after a long time without logging in to their WordPress website. But there's no need to worry. As long as you have the database access, retrieving the username and password is easy.
Login to phpMyAdmin and find your website's database. Look for the wp_users table and the user_login field contains the usernames. Alternatively, you can execute the following SQL query to see the first 30 usernames.
SELECT * FROM `wp_users` LIMIT 0 , 30;
UPDATE wp_users SET user_pass = '21232f297a57a5a743894a0e4a801fc3' WHERE id = 1;
Note: Change the id to the one you found above. After the update, the password will be admin
.
I come from China and I am a freelancer. I specialize in Linux operations, PHP, Golang, and front-end development. I have developed open-source projects such as Zdir, ImgURL, CCAA, and OneNav.