Reset WordPress Admin Password in Database with SQL

Hi guys, let’s see in this trick, how you can reset the WordPress admin password in the database with SQL command. The SQL command will update the password in database.

Use case of this trick when you forget the password and want to reset it, but you don’t have access to the email to reset the password, but you have phpMyAdmin access.

So let’s see how to reset the WordPress admin password in the database through phpMyAdmin with SQL command.

UPDATE `wp_users` SET `user_pass` = MD5( 'your_new_password_here' ) WHERE `wp_users`.`user_login` = "username";

Run the above UPDATE SQL command in SQL editor of phpMyAdmin to update the user’s password by MD5 encryption. You can reset the password of any user.

See Also: How to Add an Admin User in WordPress Programmatically?

Being Tricky 😉