how to reset wordpress admin password from sql

RESETTING THE ADMINISTRATOR PASSWORD IN THE DATABASE
1. Log in to cPanel.
2. In the Databases section of the cPanel home screen, click phpMyAdmin.
3. In the left-hand pane of phpMyAdmin, click the WordPress database. A list of tables in the database appears.
4. On the top menu bar, click SQL.
5. Copy and paste the following statement into the SQL query text box. Replace new_password with the new password, and replace admin_username with the administrator’s username.

UPDATE `wp_users` SET `user_pass` = MD5( 'new_password' ) WHERE `wp_users`.`user_login` = "admin_username";

Leave a Reply

Your email address will not be published.

%d bloggers like this: