Library Technology – Reviews, Tips, Giveaways, Freeware

How to Reset WordPress Admin Password from SQL

Posted In WordPress, Wordpress tips - By Techtiplib on Tuesday, June 19th, 2012 With No Comments »

If you are using wordpress platform then the problems comes if you forgot your wordpress admin password.

Don’t worry if you forgot the wordpress admin password. There two ways to reset your wordpress admin password that is from lost your password menu and from SQL, but in this article I just share how to reset your wordpress password from SQL.

An easy way to reset wordpress admin password via SQL, please follow the step below:

  • Please login to your Cpanel account then select phpMyAdminWordPress Admin Password 1

 

  • After in phpMyAdmin please select the WordPress database name that you forgot it 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 please write the following SQL query below:
    UPDATE `wp_users` SET `user_pass` = MD5( “new_password_here” ) WHERE `wp_users`.`user_login` = “admin_username”; “new_password_here” – Please change this with the new password you want.
    “admin_username”
     – Please change this with the username you want.WordPress Admin Password 2

 

  • After you are ready, please 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.

Source: tricks-collections

About -

Hey, this blog belongs to me! I am the founder of TechTipLib and managing editor right now. And I love to hear what do you think about this article, leave comment below! Thank you so much…