Question: How to change wordpress password using phpmyadmin
Answer:
- Open the phpmyadmin.
- Open the database you are using in your wordpress.
- Find and open the table wp_users.
- Give new password in the user_pass field.
- Select MD5 from the functions drop down.
- Now save the table.
Now Try opening the admin by using newly used password.
You can aslo use the given query to upadate the password.
UPDATE `wp_users` SET `user_pass` = MD5('New-Password') WHERE `wp_users`.`ID` = 1;