The WordPress admin password can be reset from the WordPress database. The WordPress database can be easily accessed through phpMyAdmin tool available with your web hosting account.
Once you are in phpMyAdmin, select the WordPress database folder from the left navigation bar. The page will refresh and and the WordPress 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( ‘new_password_here’ ) WHERE `wp_users`.`user_login` = “admin_username”;
- "new_password_here" – Enter the new password you wish to use for your WordPress login.
- "admin_username" – replace this with the username the password should be updated for.
Once you enter the new password and the correct username, click on the GO button to submit the query. If the query is executed correct and no errors are displayed then you should be able to login with the new password.
If there's any problem while resetting the password, contact your web hosting provider for further assistance. AKLWEB Host provides the best WordPress hosting services and such requests are handled with ease.
