You are here:

How to Reset WordPress Admin Password from SQL

 

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 phpMyAdmin

How to reset WordPress Admin Password from SQL

  • 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.

Code for How to reset WordPress Admin Password from SQL

  • 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. Congrats!
Posted by Fz 0 Responses
     

Leave a Reply to this Post

Jun
18
 
 
Friends
Recent Comments
  • Arc: I can't open file..message is "Can't create Process! Seach the file?" why?? i have...
  • ginrashid: need reseter for canon pixma p200 please...
  • ginrashid: i need reseter for canon pixma p200 please help...
  • ginrashid: i need reseter for canon pixma p200 .........
  • tokojubel: it's very hard work for making money online, but we must hard for promoting our site...