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

Recent Comments
  • Sudhakar: need reset utility for epson Tx720wd, if anyone have please...
  • excelive: powerful tools for old epson printer. thanks for...
  • nasir: in DCP t-300 it will not work.. is their any other procedure to rectify that...
  • jeff: The requested URL /download/10385082/ was not found on this...
  • nasir: very...