How to reset WordPress administrator password

Sometime you may need to reset your admin password for your WordPress blog. You have to reset your password through the WordPress database directly in case if the forgot password doesn’t work. The most convenient way to manage the database is via the phpMyAdmin tool at your web hosting account.In phpMyAdmin, select your WordPress database from the drop-down menu on the left. The page will refresh and the database’s tables will be displayed on it. Open the SQL tab (look at the top navigation bar).

In the text field write the following SQL query:

UPDATE `wp_users` SET `user_pass` = MD5( ‘your_new_password’ ) WHERE `wp_users`.`user_login` = “your_admin_username”;

“your_new_password” – replace this with the new password you wish to use.

“your_admin_username” – replace this with the username the password should be updated for.

Once you are ready, click on the “GO” button to submit the query. If everything goes fine without errors, you should be able to login to WordPress with the new password.

Leave a Reply